Page History
SQL Inventory Manager provides a general overview of the users and roles for SQL Server instances and databases. This overview lists some basic information that allows users to better classify and identify discovered instances. It also provides a useful context when users look at an instance under management.
The Users and Principals Principals dialog provides a general overview of logins, roles, users, and schemas for an instance or for a selected database. The information on this dialog allows users to better classify and identify discovered instances. There are two different views on the Users and Principals dialog, the instance level view and the database level view.at either Instance Level or Database Level.
Accessing the Users and Principals view.
There are two ways to access the Users and Principals view. On
From the Instance Summary
...
On the database dialog click View Database Principals, this link opens the Users and Principals dialog showing the database level view for the currently selected database.
section
- Go to the instance summary section.
- Select an instance.
- On the Instance Summary
...
- panel,
...
- click View Instance Principals
...
- . This opens the Users and Principals dialog
...
- at the instance level view
...
- .
...
From the
...
Database
...
dialog
- Go to the instance summary section.
- Select an instance.
- Go to the Databases section and select a database
- Click View Database Principals under the Security Information Section. This opens
Add a link from the Instance Summary section of the Instances view, directly underneath the View Configuration link. This link should open the Users and Principals dialog with the “Instance” level selected.
- Add a header “Security Information” and a link “View Database Principals” from the Database Details dialog as shown in the mockup. This link should open the Users and Principals dialog with at the database from which the user is navigating selected.
...
- level view
...
The Instance Level view contains two sections, Logins and Roles
In the instance level view you can view 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:
Excerpt |
---|
SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > > |
...
- .
For more details on the available information on each views refer to these documents:
Children Display |
---|
...