Groups Properties

Properties of groups.

Click Properties on your group to initiate the Group Properties wizard to modify these database properties:

Wizard Option	Database Properties
General	Users – to change the users in your group, use: Add – select a user and click Apply to add the user to your group. Remove – select a user and click Apply.
Command Permissions	Permissions to create database objects – select the kind of permissions to grant the group: 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.

Wizard Option

Database Properties

General

Users – to change the users in your group, use:
- Add – select a user and click Apply to add the user to your group.
- Remove – select a user and click Apply.

Command Permissions

Permissions to create database objects – select the kind of permissions to grant the group:

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.