Table of Contents

Search

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

Administrator Guide

Administrator Guide

Sybase Dynamic Data Masking Administrator Required Privileges

Sybase Dynamic Data Masking Administrator Required Privileges

The Dynamic Data Masking administrator must have privileges to access sensitive tables and columns.
Log in to a Sybase client as an administrator that is not the Dynamic Data Masking administrator and run the following commands:
  • SP_ADDLOGIN <DDM Admin>, <DDM Admin password>
  • GRANT ROLE SSO_ROLE 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 command from the master database:
GRANT SET PROXY TO <DDM Admin>

0 COMMENTS

We’d like to hear from you!