Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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, IDERA 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 Compliance Manager permissions and database access rights. For more information, see Available login permissions.

...

  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 Compliance Manager 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.

 

Excerpt
SQL Compliance Manager audits all activity on your server. Learn more > >