Managing Access to Oracle Database@AWS

Learn about the policies, groups and roles used to manage access to Oracle Database@AWS. Using these groups and roles ensures that assigned users have the appropriate permissions to operate the service.

Groups in Oracle Cloud Infrastructure IAM

Use the following groups in your Oracle Cloud Infrastructure (OCI) tenancy.

OCI group name Description
aws-db-family-administrators Group to manage DB family actions
aws-network-administrators

Group to manage Network actions

aws-db-family-readers Group to read DB family actions
aws-network-readers Group with read permissions for Network actions
aws-exa-infra-administrators Group to manage Exadata Infrastructure actions
aws-exadb-vm-cluster-administrators Group to manage Oracle Database Home actions
aws-exa-cdb-administrators Group to manage Oracle Container Database (CDB) actions
aws-exa-pdb-administrators Group to manage Oracle Pluggable Database (PDB) actions
aws-vm-cluster-administrators Group to manage Exadata VM cluster and Oracle Database Home actions
aws-costmgmt-administrators Group to manage usage reports 
aws-metrics-readers Group to read metrics
aws-dbmgmt-administrators Group for Database Management actions

See the following topics for more information:

Policies Automatically Created in OCI During Onboarding

The onboarding with Oracle Database@AWS automatically creates a set of policies in your OCI tenancy that lets the multicloud service and authorized user groups perform certain actions. The information on these policies is for reference only.

Important

These policies must not be changed or deleted. They're required to avoid operational issues in the multicloud environment.

The policies are created in two compartments: the root compartment and the base compartment for the multicloud service. The base compartment is automatically created in the OCI tenancy during onboarding. The base compartment is named MulticloudLink_AWS_<YYYYMMDDHHMMSS> (where YYYYMMDDHHMMSS is the compartment creation timestamp).

The following table lists the policies created automatically during onboarding.

Compartment Policy Unique Name Purpose
base MulticloudLink_AWS_Management Lets the multicloud service manage all multicloud resources in the base compartment.
root MulticloudLink_AWS_<UNIQUE_ID>_User_Group_Policies Lets authorized user groups perform operations on DB resources.
root MulticloudLink_AWS_<UNIQUE_ID>_Observability Lets the multicloud service perform observability operations.
root MulticloudLink_AWS_<UNIQUE_ID>_Tenant_Level Lets the mutlicloud service perform tenancy-level operations.