ANY system privilege for GTREP schema user
search cancel

ANY system privilege for GTREP schema user

book

Article ID: 369095

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

In the security review it has been detected that GTREP DB user has 'ANY' privileges. They have recommended us to revoke
Unauthorized users or roles that  have been granted with ANY keyword privileges, according to their reports.

In the product documentation, it says: "For Oracle, verify that the specified dbuser has the following roles and privileges." But couldn't find the reason. 

In conclusion, would like to know if there could be any trouble if ANY privileges are excluded? Or do are there any alternative privileges instead of ANY?

Environment

TDM 4.10.x , 4.11.x

Resolution

Upon detailed analysis, it can be confirmed that ANY is not mandatory in assigned privileges. ANY privileges can be excluded from the listed permissions.