Minimum DB level permissions for GTREP user in Oracle

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

As per the documentation, GTREP Repository user need all below Privileges:

• ALTER ANY PROCEDURE
• ALTER ANY TABLE
• CREATE ANY INDEX
• CREATE ANY PROCEDURE
• CREATE ANY SEQUENCE
• CREATE ANY TABLE
• CREATE ANY VIEW
• CREATE SESSION
• CREATE USER
• DROP USER
• GRANT ANY PRIVILEGE
• GRANT ANY ROLE
• INSERT ANY TABLE
• LOCK ANY TABLE

 

Environment

Release : 4.9

Component : CA Test Data Manager - Others

Cause

Due to security reasons the DBA is not willing to give all the permissions and would like to know the minimum set of permissions for GTREP user in Oracle.

Resolution

The minimum permissions to start with which we have tested the GTREP to work are listed below. During usage if need arises based on the use case, we may need to add more permissions.

grant create table to gtrep;

grant unlimited tablespace to gtrep;

grant create sequence to gtrep;

grant create view to gtrep;

grant create procedure to gtrep;

grant create trigger to gtrep;

grant create session to gtrep;

grant select on v_$session to gtrep;