Use the Role Properties window to set passwords, assign logins to roles, set permissions, hierarchically map roles, and set roles as mutually exclusive.
Option | Role Properties |
---|---|
General |
Password – the system security officer can set or expire a password for a role. |
Logins |
Login – add or remove logins assigned to a role. |
Login Profile | Login Profiles – 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. |