User-Extended Roles

Add, change, and delete user-extended roles.

• Creating a User-Extended Role
  Add a new user-extended role to the database.
• Deleting a User-Extended Role
  Delete a user-extended role from the database.
• Converting a User-Extended Role to a User
  Change a user-extended role back to a regular user.
• Adding a Grantee to a User-Extended Role
  Add a user or role as a member (grantee) of a user-extended role. Grantee inherits all underlying system privileges and roles of the user-extended role.
• Changing a Grantee's Administrative Rights on a User-Extended Role
  Change a member's (grantee's) ability to manage a user-extended role.
• Removing a Grantee From a User-Extended Role
  Remove a user or role as a member (grantee) of a user-extended role. Grantees lose the ability to use any underlying system privileges or roles of the user-extended role.
• Adding a Role to a User-Extended Role
  Add a role as an underlying role of a user-extended role. Members of the user-extended 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 user-extended role.
• Changing Administrative Rights on an Underlying Role of a User-Extended Role
  Changes a member's (grantee's) ability to manage an underlying role of a user-extended role.
• Removing a Role from a User-Extended Role
  Remove a role as an underlying role of a user-extended role. Members of the user-extended role lose the ability to use any system privileges of the underlying role.
• Adding a System Privilege to a User-Extended Role
  Add the ability of a user-extended role to perform privileged tasks associated with a system privilege.
• Changing Administrative Rights on a User-Extended Role Granted Privilege
  Change the administrative rights on a system privilege granted to a user-extended role.
• Removing a System Privilege from a User-Extended Role
  Remove a system privilege from a user-extended role.
• Viewing or Modifying Role-Based User-Extended Role Options
  View or change database option settings assigned to a user.
• Manage Role Administrators of a User-Extended Role
  Role administrators are responsible for granting and revoking user-extended roles to users and other roles. You can add and remove role administrators as needed.
• Manage Global Role Administrators of a User-Extended 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 User-Extended Role DDL Commands
  Display the SQL data description language for creating a user-extended role. The SQL code can be a useful reference and training tool.
• Viewing or Modifying User-Extended Role Properties
  View or change user-extended role properties such as password, login policy and database object permissions.
• Changing a User-Extended Role Password
  Change the password for another role-base user-extended role.
• Forcing a User-Extended Role to Change their Password
  Force a role-based user-extended role to change their password the next time he or she logs in.
• Unlocking a User-Extended Role Account
  Unlock a locked role-based user-extended role account.
• Changing a User-Extended Role Login Policy
  Assign a role-based user-extended role a different login policy.
• Role-Based User-Extended Role Privilege Summary
  A list of the system privileges and object permissions required to complete the various role-based user-extended role tasks.