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

Compare with Current View Page History

« Previous Version 2 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


SCREENSHOTS


Roles

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

 

Name:  The name assigned to the selected role.

Object Type: Database Role or Application Role.

SCREENSHOTS


Owner

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

Name:
Owner:

SCREENSHOTS

  • No labels