Users Properties

Use the Users Properties window to modify permissions to access database objects and commands and modify login aliases.

Option Users Properties
General
  • Groups – to change the group for the user, select from the list of groups.
Objects Owned Select the database objects that your user owns in this database.
Command Permissions
Permissions to create database objects – select the kind of permissions to grant the user:
  • Create default
  • Create procedure
  • Create rule
  • Create table
  • Create view
  • Create encryption key

To revoke the permissions, select the permissions and click Revoke, then Apply.
Object Permissions

Permissions to access database objects – use the Grant Permission and Revoke Permission wizards to grant or revoke permissions and predicated privileges for specific database operations such as insert, delete, update, reference, and decrypt for specific database objects such as tables, procedures, encryption keys, and so on.
Login Aliases Logins – to change logins aliases:
  • Add – select a login and click Apply to add the login to your user alias.
  • Remove – select the login from the list, and click Remove, then Apply.
Parent topic: Manage Users