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
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.
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.
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.
Allows you to refresh the Logins list with current information.
Provides the logon name of the SQL Server login account.
Indicates whether the login is a Windows user or group.
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.