Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The database level view contains three sections.

Users

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

 

Name: The Shows the name of the a user.

User Type:  The Shows 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.  (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:

...

Object Type: Database Role or Application Role.

SCREENSHOTS

Owner

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

...