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. Configuration for MicroStrategy
  9. Access Control
  10. Logs
  11. High Availability
  12. Server Control
  13. Performance Tuning
  14. Troubleshooting
  15. 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!