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

Administrator Guide

Administrator Guide

Microsoft SQL Server Database Administrator Required Privileges

Microsoft SQL Server Database Administrator Required Privileges

The database administrator must have privileges to access sensitive tables and columns.
Log in as the system administrator and run the following commands:
  • USE master;
  • CREATE LOGIN <DBA Username> WITH PASSWORD=<DBA Password>, DEFAULT_DATABASE = <default database>;
  • GRANT CONTROL SERVER TO <DBA Username>;
  • USE <default database>;
  • CREATE USER <db user> FOR LOGIN <dba user login>;

0 COMMENTS

We’d like to hear from you!