Grant Compatibility Roles

Granting a compatibility role is semantically equivalent to granting each of its underlying system privileges and roles.

• Granting SYS_AUTH_SA_ROLE
  Allows users to perform authorized tasks pertaining to data and system administration responsibilities.
• Granting SYS_AUTH_SSO_ROLE
  Allows users to perform authorized tasks pertaining to security and access control responsibilities.
• Granting SYS_AUTH_DBA_ROLE
  Allows users to perform all authorized tasks.
• Granting SYS_AUTH_BACKUP_ROLE
  Allows users to perform all backups.
• Granting SYS_AUTH_MULTIPLEX_ADMIN_ROLE
  Allows users to perform authorized tasks to manage multiplex.
• Granting SYS_AUTH_OPERATOR_ROLE
  Allows users to checkpoint databases, drop connections (including those for users with SYS_AUTH_DBA_ROLE), back up databases, and monitor the system.
• Granting SYS_AUTH_PERMS_ADMIN_ROLE
  Allows users to manage data privileges, groups, authorities, and passwords.
• Granting SYS_AUTH_PROFILE_ROLE
  Allows users to enable or disable server tracing for application profiling.
• Granting SYS_AUTH_READFILE_ROLE
  Allows users to read to a file that is resident on the server machine.
• Granting SYS_AUTH_READCLIENTFILE_ROLE
  Allows users to read to a file that is resident on the client machine.
• Granting SYS_AUTH_RESOURCE_ROLE
  Allows users to create new database objects, such as tables, views, indexes, or procedures.
• Granting SYS_AUTH_SPACE_ADMIN_ROLE
  Allows users to manage dbspaces.
• Granting SYS_AUTH_USER ADMIN_ROLE
  Allows users to manage external logins, login policies, and other users.
• Granting SYS_AUTH_VALIDATE_ROLE
  Allows users to validate or check tables, materialized views, indexes, or databases in the system store. The objects can be owned by any user.
• Granting SYS_AUTH_WRITEFILE_ROLE
  Allows users to write to a file that is resident on the server machine.
• Granting SYS_AUTH_WRITECLIENTFILE_ROLE
  Allows users to write to a file that is resident on the client machine.