You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

The database level view contains three sections.


Users

The Users tab shows all the roles for the database with the following columns:

 

Name:

User Type: The user type as shown in SSMS under Instance> Databases> {Database Name}> Security> Users> {User}> General … 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 login name associated with the user. This value may be blank (or null, which should be displayed as a 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


Roles

The Roles tab there should be a paginated grid showing all roles for the database with the following columns:

 

Name: 

Object Type: Database Role or Application Role


Owner

The Schemas shows all roles for the server with the following columns: 

Name:
Owner:

 

  • No labels