Use the following checklist to help you implement and configure logins that meet your auditing and SQL Server security needs.

Follow these steps ...

Ensure your Windows logon account has sysadmin privileges on the SQL Server instance that hosts the Repository databases. For more information, see Permissions requirements.

Review how SQL Compliance Manager enforces your native SQL Server security model. For more information, see How Console security works.

Review the SQL Server privileges granted with SQL compliance manager permissions. For more information, see Available login permissions.

Create a login for each person who should generate reports using the Management Console, and then apply the Can view and report on audit data permission to each login. For more information, see Create a login.

Create a login for each person who should administer auditing in the Management Console, and then apply the Can configure settings and view audit data permission to each login. For more information, see Create a login.

 

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