You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Consider creating a login for each security administrator, database administrator, or auditor who uses the Management Console. Creating multiple logins allows you to enforce more granular security. When you create a login, SQL Compliance Manager also creates a SQL Server login on the SQL Server instance that hosts the Repository databases.

Assign the new login the appropriate SQL CM permissions and database access rights. For more information, see Available login permissions.

To create a console login:

  1. Select Logins in the Administration tree, and then click New Login.
  2. Specify the name of a valid Windows user account and whether this account should have access to audit data, and then click Next. You can grant or change access later.
  3. Specify which level of SQL CM permissions you want to grant this login, and then click Next. For more information, see Available login permissions.
  4. Review the summary, and then click Finish.

 

SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels