Page History
The database level view contains three sections.
Users
Database Level view groups information in three tabs Users, Roles, and Schemas.
Logins
The LoginsThe Users tab shows all the roles for the database with the following columns:
Name: Shows the name of a user.
User Type: The user type as shown in SSMS under Instance> Databases> {Database Name}> Security> Users> {User}> General … User TypeShows the user type. Possible values are SQL User with Login, SQL User without Login, User mapped to a certificate, User mapped to an asymmetric key, and Windows User.
Login Name: The Shows the login name associated with the a user. This value may be blank (or null, which should be displayed as a null values display as blank).
Has Access: A non-editable checkbox indicating true or false. This should match the list shown in IDERA SQL Secure under Instance> Databases> {Database Name}> Security> Users Indicates the access status of a user.
SCREENSHOTS
Roles
The Roles tab there should be a paginated grid showing all shows all the roles for the a database with the following columns:
Name: The name assigned to the selected role.
Object Type: Database Role or Application Role.SCREENSHOTS
Owner
Schemas
The Schemas shows Schemas tab shows all roles for the server with the following columns:
Name: Shows the name of the schema.
Owner:
...
Shows the owner of the schema.
Info |
---|
The Schemas tab isn't available for SQL2000 servers. |