Dynamic Data Masking Accelerator for use with SAP

Back Next

Create Dynamic Data Masking Database Administrator User

Create a Dynamic Data Masking database administrator user to use the accelerator.

Connect to the database with the sys user and run the following database commands:

CREATE USER DDMUSER IDENTIFIED BY XXXX

ALTER USER DDMUSER QUOTA UNLIMITED ON USERS

GRANT BECOME USER TO DDMUSER

GRANT CREATE SESSION TO DDMUSER

GRANT ALTER SESSION TO DDMUSER

GRANT SELECT ANY TABLE TO DDMUSER

GRANT SELECT ANY DICTIONARY TO DDMUSER

GRANT EXECUTE ON UTL_HTTP TO DDMUSER

GRANT DBA TO DDMUSER

The database commands create a database user with the user name DDMUSER and password XXXX. You can change the values of the user name and password.

Watch

Comments

0 COMMENTS

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