Role Properties

Use the Role Properties window to set passwords, assign logins to roles, set permissions, hierarchically map roles, and set roles as mutually exclusive.

Click the Name field of the role, then click the drop-down arrow and select Properties.

Pages Properties
General Password – the system security officer can set or expire a password for a role.
Logins Add or remove logins assigned to a role.
Login Profile Add or remove login profiles assigned to a role
Hierarchy Create roles that are hierarchically mapped or aliased to another role.
Exclusivity Control privileges of roles by defining the roles as mutually exclusive.
Command Permissions Grant or revoke command permissions for the selected role.
Object Permissions Grant or revoke object permissions and predicated privileges for a selected role.
Privileges Grant or revoke system privileges to roles at the server or database level.