Online Documentation for SQL Administrator for SQL Server
Database users
A Database User is a database-level security principal enabling object access permission control at the finest level of granularity. A user represents a single SQL Server login within the scope of the database in which the user is defined.
Use the context menu to:
create a new user
edit the selected user(s)
drop selected user(s)
- rename selected user
- create the object copy on the same server
- clone the object copy to another server
create and print the report
Alternatively, you can use the 'Insert' button to create a user, 'Enter' button to edit user(s) and 'Delete' button to drop user(s).
To view database users select a database from the Database drop-down list which is situated on the toolbar.
The list displays the existing database users as a grid with the following columns: Name, User type, Orphaned, Can Connect, DB Owner, Sysadmin, Login, Certificate, Asymmetric Key, Default Schema. If more convenient, you can change the order of the columns by dragging their headers horizontally. See the Working with grid section of the SQL Administrator documentation to find out operations that can be performed with the grid.
To open a Database User in the User Editor, double-click it in the grid. Alternatively, you can right-click the Database User alias and select the Edit User(s) context menu item.
See also:
