SQL Server - Security Manager

Toolbar Operations - Depending on the Tab selected, there are different Toolbar Operations available.

Available operations for Logins & Server Roles tab
Refresh : Refreshes all tabs in the security manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Database: Chooses from which database you want to see the users and roles
Expand All: Expands all tree nodes in the tree tab
Collapse All: Collapses all tree nodes in the tree tab
Create Login: Creates a new login
Alter Login: Edits selected login
Drop Login: Drops selected login
Login Properties: Shows properties of selected login
Alter Server Role: Edits selected server role
Server Role Properties: Shows properties of selected server role

Available operations for Logins tab
Refresh : Refreshes all tabs in the security manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else
Database: Chooses from which database you want to see the users and roles
Expand All: Expands all tree nodes in the tree tab
Collapse All: Collapses all tree nodes in the tree tab
Create Login: Creates a new login
Alter Login: Edits selected login
Drop Login: Drops selected login
Login Properties: Shows properties of selected login

Available operations for Server Roles tab
Refresh : Refreshes all tabs in the security manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else
Database: Chooses from which database you want to see the users and roles
Alter Server Role: Edits selected server role
Server Role Properties: Shows properties of selected server role

Available operations for Database Users & Roles tab
Refresh : Refreshes all tabs in the security manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else
Database: Chooses from which database you want to see the users and roles
Expand All: Expands all tree nodes in the tree tab
Collapse All: Collapses all tree nodes in the tree tab
Create User: Creates a new user
Alter User: Edits selected user
Drop User: Drops selected user
User Properties: Shows properties of selected user
Create Role: Creates a new role (group)
Alter Role: Edits selected role
Drop Role: Drops selected role
Role Properties: Shows properties of selected role

Available operations for Users tab
Refresh : Refreshes all tabs in the security manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else
Database: Chooses from which database you want to see the users and roles
Create User: Creates a new user
Alter User: Edits selected user
Drop User: Drops selected user
User Properties: Shows properties of selected user

Available operations for Roles tab
Refresh : Refreshes all tabs in the security manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else
Database: Chooses from which database you want to see the users and roles
Create Role: Creates a new role (group)
Alter Role: Edits selected role
Drop Role: Drops selected role
Role Properties: Shows properties of selected role
 

Logins Tab - Provides a list of logins in the MS SQL database

Name: Name of the login
Type: Login type(NT User, NT Group, Standard)
Access: Whether the login has been granted access to the server
Default Database: Name of the default database of the user when a connection is established
Has Roles: Whether the login has roles
Date Created: Date when the login was created

Server Roles Tab - Provides a list of server roles in the MS SQL database

Full Name: Descriptive name of the server role
Name: Short name of the server role
Description: Detailed description of the server role

Users Tab - Provides a list of users in the MS SQL database

Name: Name of the user
Login Name: User login name
Access: Whether the user has been granted access to the server