The Logins window allows you to view a list of logins that are active in IDERA SQL Secure. This list provides the name, type of login, SQL Server access, and permissions in SQL Secure for each login. From this window, you can add new logins, delete logins, and edit login properties.

A user must have a SQL Secure login to use SQL Secure features, such as Reports.

Each SQL Secure access level maps to a specific SQL Server role that SQL Secure provides in the Repository. You can assign these SQL Secure roles to an existing login using SQL Server Enterprise Manager or Management Studio.

The following information is displayed in the Logins window:

ColumnDescription
NameList the logins that are associated with the SQL Secure Repository database.
TypeDescribes the type of login (Standard, windows Group, Windows User)
SQL Server AccessDescribes the type of access the user has on the SQL Secure Repository database.
Permissions in SQL SecureDescribes the type of access the user has within the SQL Secure Console.

To know how to add or edit logins, go Add New Login and/or Edit Login settings

SQL Secure tells you who has access to what on your SQL Server databases. Learn more > >
  • No labels