Standalone Roles

Add, change, and delete stadalone roles.

• Creating a Standalone Role
  Add a new standalone role to the database.
• Deleting a Standalone Role
  Delete a standalone role from the database.
• Adding a Grantee to a Standalone Role
  Add a user or role as a member (grantee) of a standalone role. Grantee inherits all underlying system privileges and roles of the standalone role.
• Changing a Grantee's Administrative Rights on a Standalone Role
  Changes a member's (grantee's) ability to manage a standalone role.
• Removing a Grantee from a Standalone Role
  Remove a user or role as a member (grantee) of a standalone role. Grantees lose the ability to use any underlying system privileges or roles of the standalone role.
• Adding a Role to a Standalone Role
  Add a role as an underlying role of a standalone role. Members of the standalone role inherit all system privileges and roles 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 Standalone Role
  Changes a member's (grantee's) ability to manage an underlying role of a standalone role.
• Removing a Role from a Standalone Role
  Remove an underlying role from a standalone role. Grantees of the standalone role lose the ability to use any system privileges of the underlying role or administer the underlying role.
• Adding a System Privilege to a Standalone Role
  Add a system privilege to a standalone role.
• Changing Administrative Rights on a Privilege Granted to a Standalone Role
  Change the administrative rights on a system privilege granted to a standalone role.
• Removing a System Privilege from a Standalone Role
  Remove a system privilege from a standalone role.
• Manage Standalone Role Administrators
  Role administrators are responsible for granting and revoking standalone roles to users and other roles. You can add and remove role administrators as needed.
• Manage Global Role Administrators of a Standalone Role
  A global role administrator is any user granted the MANAGE ROLES system privilege. However, not all roles can be managed by global role administrators.
• Generating Standalone Role DDL Commands
  Display the SQL data description language for creating a standalone role. The SQL code can be a useful reference and training tool.
• Viewing or Modifying Role-Based Standalone Role Properties
  View or change standalone role comments and database object permissions.
• Role-Based Standalone Role Privilege Summary
  A list of the system privileges and object permissions required to complete the various role-based standalone role tasks.