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 create a new user

Edit edit the selected user(s)

Drop drop selected user(s)

  • rename selected user
  • create the object copy on the same server
  • clone the object copy to another server

Print 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).

 

Database Users

 

 

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.