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. |