Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Connection Management
  5. JDBC Client Configuration
  6. ODBC Client Configuration
  7. Access Control
  8. Logs
  9. High Availability
  10. Server Control
  11. Performance Tuning
  12. Troubleshooting

Administrator Guide

Administrator Guide

Oracle Dynamic Data Masking Administrator Required Privileges

Oracle Dynamic Data Masking Administrator Required Privileges

The Dynamic Data Masking administrator must have privileges to access sensitive tables and columns.
Run the following database commands to create a Dynamic Data Masking administrator user and grant the required privileges:
  • CREATE USER <DDM Admin> IDENTIFIED BY <XXXX>
  • ALTER USER <DDM Admin> QUOTA UNLIMITED ON USERS
  • GRANT BECOME USER
  • GRANT CREATE SESSION TO <DDM Admin>
  • GRANT ALTER SESSION
  • GRANT SELECT ANY TABLE TO <DDM Admin>
  • GRANT SELECT ANY DICTIONARY TO <DDM Admin>

Additional Privileges for SELECT * Statements

If your Dynamic Data Masking security rules need to support column masking on SELECT * statements, you must also run the following commands:
  • CREATE USER <DDM Admin> IDENTIFIED BY <XXXX>
  • ALTER USER <DDM Admin> QUOTA UNLIMITED ON USERS
  • GRANT BECOME USER TO <DDM Admin>
  • GRANT CREATE SESSION TO <DDM Admin>
  • GRANT ALTER SESSION TO <DDM Admin>
  • GRANT SELECT ANY TABLE TO <DDM Admin>
  • GRANT SELECT ANY DICTIONARY TO <DDM Admin>
  • GRANT EXECUTE ANY TYPE TO <DDM Admin>
  • GRANT SELECT_CATALOG_ROLE TO <DDM Admin>
  • GRANT GRANT ANY OBJECT PRIVILEGE TO <DDM Admin>
  • GRANT CREATE ANY TABLE TO <DDM Admin>
  • GRANT DROP ANY TABLE TO <DDM Admin>
  • GRANT INSERT ANY TABLE TO <DDM Admin>

0 COMMENTS

We’d like to hear from you!