System Roles

System roles are automatically created in each newly created or database and has been granted specific system privileges.

You can grant and revoke system roles to users and roles, but you cannot delete them. System roles cannot own objects.

• View Grantees of a System Role
  Display a list of the users and roles granted membership to a system role.
• View Underlying Roles of a System Role
  Display a list of the underlying roles granted to a system role.
• View System Privileges Granted to a System Role
  Display a list of the system privileges granted to a system role.
• Adding a Grantee to a System Role
  Add a user or role as a member (grantee) of a system role. Grantee inherits all underlying system privileges and roles of the system role.
• Removing a Grantee from a System Role
  Remove a user or role as a member of a system role.
• Adding a Role to a System Role
  Add a role as an underlying role of a standalone role. Members of the system role inherit the system privileges of the underlying role, but do not become members of the underlying role. Members of the underlying role do not become members of the standalone role.
• Changing Administrative Rights on an Underlying Role of a System Role
  Changes a member's (grantee's) ability to manage an underlying role of a system role.
• Removing a Role from a System Role
  Remove a role as an underlying role of a system role. Members of the system role lose the ability to use any system privileges of the underlying role.
• Adding a System Privilege to a System Role
  Add a system privilege to a system role.
• Changing Administrative Rights on a System Role Granted Privilege
  Change the administrative rights on a system privilege granted to a system role.
• Removing a System Privilege from a System Role
  Remove a system privilege from a system role.
• Role-Based System Role Privilege Summary
  A list of the system privileges and object permissions required to complete the various role-based system role tasks.