Stored Procedure Accelerator Guide for Oracle

Back Next

Step 2. Grant Dynamic Data Masking Administrator Privileges

Create the Dynamic Data Masking administrator and grant the required privileges.

Grant the following privileges to allow Dynamic Data Masking impersonation on the database:

CREATE USER <DDMADMIN> IDENTIFIED BY <XXXX>

ALTER USER <DDMADMIN> QUOTA UNLIMITED ON USERS

GRANT BECOME USER TO <DDMADMIN>

GRANT CREATE SESSION TO <DDMADMIN>

GRANT ALTER SESSION TO <DDMADMIN>

GRANT SELECT ANY TABLE TO <DDMADMIN>

GRANT SELECT ANY DICTIONARY TO <DDMADMIN>

GRANT EXECUTE ANY PROCEDURE TO <DDMADMIN>

Grant the following privileges to the Dynamic Data Masking administrator to use the Stored Procedure Accelerator for Oracle:

GRANT CREATE ANY PROCEDURE TO <DDMADMIN>

GRANT DROP ANY PROCEDURE TO <DDMADMIN>

GRANT EXECUTE ANY TYPE TO <DDMADMIN>

GRANT SELECT_CATALOG_ROLE TO <DDMADMIN>

GRANT GRANT ANY OBJECT PRIVILEGE TO <DDMADMIN>

GRANT CREATE ANY TABLE TO <DDMADMIN>

GRANT DROP ANY TABLE TO <DDMADMIN>

GRANT INSERT ANY TABLE TO <DDMADMIN>

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.