Page History
...
- SQL authentication logins, such as the sa account, who are members of the sysadmin fixed server role
- Windows authentication logins who are members of the local Administrators group
Available actions
New Login
Allows you to create a SQL Server login. SQL Compliance Manager creates this login at the SQL Server instance that hosts the Repository databases. For more information, see Create a login.
View Login Properties
Allows you to view details about permissions settings and database access. For more information, see Assign permissions to a login.
Delete
Allows you to delete the selected SQL Server login. Deleting a login removes the login from the SQL Server instance that hosts the Repository databases. This login will no longer be able to view or report on audit data, and the Windows user account associated with this login will no longer be able to access the Management Console.
| Note | ||
|---|---|---|
| ||
Deleting a SQL Server login from the SQL CM´s security, will also delete the SQL Server login and all associated databases users (if any) from the repository SQL Server´s security. |
Refresh
Allows you to refresh the Logins list with current information.
...
Indicates whether security access is permitted or denied to the SQL Server instance that hosts the Repository databases.
Web Application Access
Indicates whether the login has permissions to the Web Application Access or if it does not.
Permissions in SQL Compliance Manager
Indicates which SQL Compliance Manager permission the selected login has on the Repository databases.
...