Versions Compared

Key

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

The database level view contains three sections.

Users

Database Level view groups information in three tabs Users, Roles, and Schemas

Logins

The LoginsThe 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
Image Added

Roles

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

Name:  The name assigned to the selected role.

Object Type: Database Role or Application Role.SCREENSHOTS


Image AddedOwner

Schemas

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

Name:  Shows the name of the schema.
OwnerShows the owner of the schema.

Info

The Schemas tab isn't available for SQL2000 servers.


Image Added


Scroll Ignore

Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|
Newtabfooter
aliasProducts
urlhttps:

...

//www.idera.com/productssolutions/sqlserver
|
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse