Page History

...

• On the Instance Summary section, click View Instance Principals to open the Users and Principals dialog showing the instance level view for the currently selected instance. 
• On the database dialog, click View Database Principals to open the Users and Principals dialog showing the database level view  for the currently selected  database.

Instance level view

The Instance Level view contains two tabs, Logins and Roles.

Logins 

The Logins tab shows a list of all the logins for a server with the following columns:

Name:  The name of the Windows user, Windows group, or SQL user.

Object Type: Windows User, Windows Group, or SQL User.

Member Of:  A list of the roles the user is a member of, separated by tabs, and line wrapping.

Connect Permission: Granted or Denied.

Login Status: Enabled or Disabled.

Roles

The Roles tab shows all roles for the server with the following columns:

Name: The name of the role.

Members: A list of the logins which are members of this role, comma separated and word wrapping.

Database level view

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:

...