Page History

...

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.

...

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.

...

This dialog will allow users to view logins, roles, users, and schemas for the entire instance or for a selected database.

...

The instance name and, if appropriate, the database name will be shown at the upper left.

Database level view

The database level view contains three sections.

Users

The Users tab shows all the

When viewed at the Instance level

...

There should be a 2 tab control with the tabs “Logins” and “Roles”

...

On the “Logins” tab there should be a paginated grid showing all logins for the 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

  • The list may be validated in SSMS in the server tree under Instance -> Security -> Logins

  • For any individual user this data can be validated in SSMS by viewing Login Properties and viewing the data on the General, Server Roles, and Status tabs

  • This data may also be validated using IDERA SQL Secure

  • The grid should indicate the total number of logins in the lower left

  • The list should default to 10 rows per page and use the standard page control for navigation

  • The grid should follow CCL styling

• On the “Roles” tab there should be a paginated grid showing 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. This may be a long list so the column should be as wide as possible.

• The list may be validated in SSMS in the server tree under Instance -> Security -> Roles

• Note that user defined roles may be generated and these should be tested for name length and special character support

• This data may also be validated using IDERA SQL Secure

• The grid should indicate the total number of roles in the lower left

• The list should default to 10 rows per page and use the standard page control for navigation

• The grid should follow CCL styling

...

When a database is selected

...

There should be a 3 tab control with the tabs “Users,” “Roles,” and “Schemas”

• The “Schemas” tab should not be displayed for SQL 2000 servers, as that concept was not used in SQL 2000

...

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:

...