Administrator Guide

Back Next

Microsoft SQL Server Authentication-Based User as Administrator

CREATE LOGIN <DDM_Admin_Login> WITH PASSWORD=<DDM_Admin_Login_password>

CREATE USER <DDM_Admin_User> FOR LOGIN <DDM_Admin_Login>;

ALTER ROLE db_datareader ADD MEMBER <DDM_Admin_User>;

GRANT VIEW DATABASE STATE TO <DDM_Admin_User>;

If your Dynamic Data Masking security rules need to support column masking on SELECT * statements, you must also run the following command:

GRANT CONTROL TO <DDM_Admin_User>

Alternatively, you can run the following commands:

GRANT ALTER ANY USER TO <DDM_Admin_User>

GRANT IMPERSONATE ON USER :: <DDM_User> TO <DDM_Admin_User>