Users and roles
Different databases use concepts of users and roles to manage the permissions in your databases. Both of them are used for access control and define a set of permissions. In some databases, a role can be a user that has the login right.
Create a user or a role
In the Database Explorer ( ) , right-click a data source node and navigate to or .
For some databases, you need to specify a database where you want to create a role or a user. In this case, you must expand the data source tree to the database node, right-click the database node and selector .
In the Create dialog that opens, enter the name of your user or role in the Name field.
Select and specify the necessary database settings.
In the Preview pane, you can view and change the generated SQL code.
You can grant a user and a role permissions for database objects.
In the Database Explorer ( ) , right-click a user or a role and select Modify Role.
In the Grants pane of the Modify dialog, click the Add button ().
You can use auto-completion for database objects.
Click the grant field, from the drop-down near each permission, select Grant or Grant with option. The Grant with option permission means that a user can grant to or revoke from other users those permissions.