Users Properties

User permissions to access database objects and commands.

Click Properties on your group to initiate the Users Properties wizard to modify these database properties:
Wizard 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 you want 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 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.

See Granting and Revoking Permissions to Groups.

Login Aliases
  • Logins – to change the logins aliases to the user, use:
    • 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.
Related tasks
Creating a Group
Creating a User
Transferring Ownership of a Database Object
Related reference
Groups Properties