Role-Based Security

Add, change, and delete users and roles and grant or revoke database system roles to same.

Role-based security is supported with database version 16.0 only.

• Role Types
  In role-based security, there are several types of roles.
• Role-Based Users
  Add, change, and delete role-based users.
• Security Implications of the Managing Grantees and Managing Roles Options
  A role can be granted to another role as a grantee (member) or as an underlying role. Each grant type has different security inheritance implications.
• User-Extended Roles
  Add, change, and delete user-extended roles.
• Standalone Roles
  Add, change, and delete stadalone roles.
• Role-Based Object Permissions on Users and Roles
  Permissions on database objects can be granted and revoked to role-based users, user-extended roles, and standalone roles, with or without administrative rights
• System Roles
  System roles are automatically created in each newly created or database and has been granted specific system privileges.
• Compatibility Roles
  Compatibility roles are automatically created in each newly created or database and has been granted specific system privileges.
• System Privileges
  System privileges control the rights of users to perform authorized database tasks.