Administrator Guide

Back Next

Oracle Database Administrator Required Privileges

The database administrator must have privileges to access sensitive tables and columns.

Run the following database commands to create a database administrator user name and password for Dynamic Data Masking:

CREATE USER ACTIVE IDENTIFIED BY <XXXX>

ALTER USER ACTIVE QUOTA UNLIMITED ON USERS

GRANT BECOME USER

GRANT CREATE SESSION TO ACTIVE

GRANT ALTER SESSION

GRANT SELECT ANY TABLE TO ACTIVE

GRANT SELECT ANY DICTIONARY TO ACTIVE

Watch

Comments

0 COMMENTS

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