4 Post Installation Configuration

RDS uses several predefined access roles to refine user access to several capabilities. A user is associated with a role by assigning them to an OCI Group. These groups are created for the client at the time of provisioning.

Note:

It can take up to an hour for a new group assignment to take effect.

Oracle Data Visualization

Oracle Data Visualization users must be assigned to one of the following groups:

Group Name Purpose

<tenant-id>-DVConsumer

For report viewers

<tenant-id>-DVContentAuthor

For report creators and maintainers

The tenant ID is made available as part of the client activation process.

Oracle BI Publisher

Oracle BI Publisher users must be assigned to one of the following groups:

Group Name Purpose

<tenant-id>-BIConsumer

For report viewers

<tenant-id>-BIContentAuthor

For report creators and maintainers

The tenant ID is made available as part of the client activation process.

Retail DB Ops Console

Users of the Retail DB Ops Console must be assigned to one of the following groups:

Group Name Purpose

RDS_MANAGEMENT_VIEWER

Allowed to view system generated AWR reports, Top SQL, DBMS Jobs in production environment

RDS_MANAGEMENT_VIEWER_PREPROD

Allowed to view system generated AWR reports, Top SQL, DBMS Jobs in pre-production environments

RDS_MANAGEMENT_OWNER

Same as VIEWER plus allowed to create custom AWR reports in production environment

RDS_MANAGEMENT_OWNER_PREPROD

Same as VIEWER_PREPROD plus allowed to create custom AWR reports in pre-production environments

RDS_MANAGEMENT_ADMINISTRATOR

Same as OWNER plus allowed to view DB Metrics and edit application properties in production environment

RDS_MANAGEMENT_ADMINISTRATOR_PREPROD

Same as OWNER_PREPROD plus allowed to view DB Metrics and edit application properties in pre-production environments