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: Shows the name of a user.

...

Has Access: Indicates the access status of  a user. 

SCREENSHOTS
Image Added

Roles

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

Name:  The name assigned to the selected role.

Object Type: Database Role or Application Role.


SCREENSHOTSImage Added

...

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