The SQL Logins tab allows you to manage the SQL Server login accounts associated with the Repository databases. Use this window to configure SQL Server security access and designate permissions within IDERA SQL Compliance Manager.
SQL Compliance Manager leverages the SQL Server security model, using SQL Server logins to authenticate access to the Repository databases and your audit data.
This tab does not list the following logins, which have read access to audit data stored in the Repository databases:
- 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.
Warning
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.
Available columns
Name
Provides the logon name of the SQL Server login account.
Type
Indicates whether the login is a Windows user or group.
Server Access
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.