Dynamic Data Masking Accelerator Guide for use with SAP

Dynamic Data Masking Accelerator Guide for use with SAP

Create Dynamic Data Masking Database Administrator User

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.