AmazonODBAutonomousDatabaseAdmin
Summary
Provides administrative access to manage Autonomous Database resources in Oracle Database@AWS. The Oracle Database@AWS User Guide says you can manage Autonomous Database Serverless resources and their backups, and view the ODB network resources they attach to.
Permissions imported from the AWS Managed Policy Reference Guide; other sections reviewed against the listed AWS sources.
Identity
- ARN
arn:aws:iam::aws:policy/job-function/AmazonODBAutonomousDatabaseAdmin- Default version
- v1
- Created
- Last edited
- Services
- ec2, iam, odb
Control-plane actions (34)
By access level: 8 List, 6 Read, 2 Tagging, 18 Write.
| Service | Granted | Access levels and limits | Granted by |
|---|---|---|---|
| EC2 | 1 of 834 | 1 List; 0 restricted, 0 conditional | ec2:DescribeAvailabilityZones |
| IAM | 1 of 190 | 1 Write; 1 restricted, 1 conditional | iam:CreateServiceLinkedRole |
| Oracle Database@AWS | 32 of 96 | 7 List, 6 Read, 2 Tagging, 17 Write; 4 restricted, 0 conditional | odb:CreateAutonomousDatabase, odb:CreateAutonomousDatabaseBackup, odb:CreateAutonomousDatabaseWallet, odb:CreateOutboundIntegration, odb:DeleteAutonomousDatabase, odb:DeleteAutonomousDatabaseBackup, odb:FailoverAutonomousDatabase, odb:GetAutonomousDatabase, odb:GetAutonomousDatabaseBackup, odb:GetAutonomousDatabaseWalletDetails, odb:GetOciOnboardingStatus, odb:GetOdbNetwork and 20 more |
EC2: 1 actions
- ec2:DescribeAvailabilityZones (List)
IAM: 1 actions
- iam:CreateServiceLinkedRole (Write)
Oracle Database@AWS: 32 actions
- odb:CreateAutonomousDatabase (Write)
- odb:CreateAutonomousDatabaseBackup (Write)
- odb:CreateAutonomousDatabaseWallet (Write)
- odb:CreateOutboundIntegration (Write)
- odb:DeleteAutonomousDatabase (Write)
- odb:DeleteAutonomousDatabaseBackup (Write)
- odb:FailoverAutonomousDatabase (Write)
- odb:GetAutonomousDatabase (Read)
- odb:GetAutonomousDatabaseBackup (Read)
- odb:GetAutonomousDatabaseWalletDetails (Read)
- odb:GetOciOnboardingStatus (Read)
- odb:GetOdbNetwork (Read)
- odb:InitializeService (Write)
- odb:ListAutonomousDatabaseBackups (List)
- odb:ListAutonomousDatabaseCharacterSets (List)
- odb:ListAutonomousDatabaseClones (List)
- odb:ListAutonomousDatabasePeers (List)
- odb:ListAutonomousDatabaseVersions (List)
- odb:ListAutonomousDatabases (List)
- odb:ListOdbNetworks (List)
- odb:ListTagsForResource (Read)
- odb:RebootAutonomousDatabase (Write)
- odb:RestoreAutonomousDatabase (Write)
- odb:ShrinkAutonomousDatabase (Write)
- odb:StartAutonomousDatabase (Write)
- odb:StopAutonomousDatabase (Write)
- odb:SwitchoverAutonomousDatabase (Write)
- odb:TagResource (Tagging)
- odb:UntagResource (Tagging)
- odb:UpdateAutonomousDatabase (Write)
- odb:UpdateAutonomousDatabaseBackup (Write)
- odb:UpdateOutboundIntegration (Write)
Data-plane actions (0)
By access level: none.
This policy grants no actions in this plane.
Excluded and conditional actions
No patterns are excluded by NotAction or Deny statements.
Resource scope and attachment
Resource scope across granted actions: mixed.
Can be attached: Yes, to users, groups and roles.
Why this tier
- Grants 20 write, tagging or permissions-management actions, short of full control of any service.
Guidance
Practical scope
AllowODBActions allows odb actions on Resource "*", including odb:CreateAutonomousDatabase, odb:UpdateAutonomousDatabase, odb:DeleteAutonomousDatabase, odb:StartAutonomousDatabase, odb:StopAutonomousDatabase, odb:RebootAutonomousDatabase, odb:ShrinkAutonomousDatabase, odb:SwitchoverAutonomousDatabase, odb:FailoverAutonomousDatabase, odb:RestoreAutonomousDatabase, the wallet and backup actions, odb:InitializeService, odb:GetOdbNetwork and odb:ListOdbNetworks. AllowEC2Actions allows ec2:DescribeAvailabilityZones. AllowSLRActions allows iam:CreateServiceLinkedRole when iam:AWSServiceName is odb.amazonaws.com. Tagging is limited to autonomous-database and autonomous-database-backup resources, and odb:CreateOutboundIntegration and odb:UpdateOutboundIntegration to autonomous-database resources.
Use cases
- Let an administrator manage Autonomous Database Serverless resources and their backups in Oracle Database@AWS, including lifecycle actions such as start, stop, reboot, shrink, switchover, failover and restore.
Prerequisites
- The policy lacks iam:PassRole and the AWS Key Management Service key describe permission. The Oracle Database@AWS User Guide says you need them when you update the encryption key on an existing Autonomous Database Serverless resource to a customer managed key, and to add them through your own customer managed policy.
- The policy lacks secretsmanager:DescribeSecret. The guide says you need it only when you supply a customer managed AWS Secrets Manager secret for an Autonomous Database Serverless admin or wallet password, and that the integration also requires iam:PassRole.
Best practices
- AWS managed policies don't grant least privilege permissions. The IAM User Guide suggests using IAM Access Analyzer to see which permissions principals actually use, then writing a custom policy or generating one with only the required permissions.
Security considerations
- The policy allows odb:DeleteAutonomousDatabase, odb:StopAutonomousDatabase, odb:FailoverAutonomousDatabase and odb:RestoreAutonomousDatabase on Resource "*".
- It allows odb:CreateAutonomousDatabaseWallet and odb:GetAutonomousDatabaseWalletDetails, which the guide describes as creating and retrieving Autonomous Database wallet details.
- It allows iam:CreateServiceLinkedRole for odb.amazonaws.com.
- You cannot change the permissions in an AWS managed policy. If AWS updates the policy, the update affects every user, group and role it is attached to.
Assignment guidance
You can attach this policy to your users, groups and roles. The reference page also links to guidance on creating a permission set using AWS managed policies in IAM Identity Center. The Oracle Database@AWS User Guide says you can attach it to your IAM identities. It fits administrators who manage Autonomous Database Serverless resources.
Related policies
Same service
- AmazonODBAutonomousVmClusterAdmin
- AmazonODBExadataInfrastructureAdmin
- AmazonODBExadataVmClusterAdmin
- AmazonODBExascaleStorageVaultAdmin
- AmazonODBExascaleVmClusterAdmin
- AmazonODBFullAccess
- AmazonODBNetworkAdmin
- AmazonODBReadOnlyAccess
Same domain
Frequently asked questions
- When should I attach AmazonODBAutonomousDatabaseAdmin?
- The Oracle Database@AWS User Guide says you can attach it to your IAM identities to manage Autonomous Database Serverless resources and their backups. Add the extra permissions it lists as missing if you use customer managed KMS keys or Secrets Manager secrets.
- What does AmazonODBAutonomousDatabaseAdmin grant?
- On all resources it allows odb actions to create, update, delete, start, stop, reboot, shrink, switch over, fail over and restore Autonomous Databases, manage wallets and backups, and list networks and versions. It also allows ec2:DescribeAvailabilityZones, creating the odb.amazonaws.com service-linked role, and tagging and outbound integration actions on Autonomous Database resources.
- What are the security risks of AmazonODBAutonomousDatabaseAdmin?
- The policy can delete, stop, fail over and restore Autonomous Databases and create and retrieve wallet details on all resources. AWS managed policies don't grant least privilege permissions, and an AWS update to the policy affects every identity it is attached to.
Policy JSON
{
"Version": "2012-10-17",
"Statement": [
{
"Sid": "AllowODBActions",
"Effect": "Allow",
"Action": [
"odb:GetOciOnboardingStatus",
"odb:InitializeService",
"odb:CreateAutonomousDatabase",
"odb:GetAutonomousDatabase",
"odb:UpdateAutonomousDatabase",
"odb:DeleteAutonomousDatabase",
"odb:ListAutonomousDatabases",
"odb:ListAutonomousDatabaseClones",
"odb:ListAutonomousDatabasePeers",
"odb:StartAutonomousDatabase",
"odb:StopAutonomousDatabase",
"odb:RebootAutonomousDatabase",
"odb:ShrinkAutonomousDatabase",
"odb:SwitchoverAutonomousDatabase",
"odb:FailoverAutonomousDatabase",
"odb:RestoreAutonomousDatabase",
"odb:CreateAutonomousDatabaseWallet",
"odb:GetAutonomousDatabaseWalletDetails",
"odb:CreateAutonomousDatabaseBackup",
"odb:GetAutonomousDatabaseBackup",
"odb:UpdateAutonomousDatabaseBackup",
"odb:DeleteAutonomousDatabaseBackup",
"odb:ListAutonomousDatabaseBackups",
"odb:GetOdbNetwork",
"odb:ListOdbNetworks",
"odb:ListAutonomousDatabaseVersions",
"odb:ListAutonomousDatabaseCharacterSets",
"odb:ListTagsForResource"
],
"Resource": "*"
},
{
"Sid": "AllowEC2Actions",
"Effect": "Allow",
"Action": [
"ec2:DescribeAvailabilityZones"
],
"Resource": "*"
},
{
"Sid": "AllowSLRActions",
"Effect": "Allow",
"Action": [
"iam:CreateServiceLinkedRole"
],
"Resource": "*",
"Condition": {
"StringEquals": {
"iam:AWSServiceName": [
"odb.amazonaws.com"
]
}
}
},
{
"Sid": "AllowTaggingActions",
"Effect": "Allow",
"Action": [
"odb:TagResource",
"odb:UntagResource"
],
"Resource": [
"arn:aws:odb:*:*:autonomous-database/*",
"arn:aws:odb:*:*:autonomous-database-backup/*"
]
},
{
"Sid": "AllowOutboundIntegrationActions",
"Effect": "Allow",
"Action": [
"odb:CreateOutboundIntegration",
"odb:UpdateOutboundIntegration"
],
"Resource": [
"arn:aws:odb:*:*:autonomous-database/*"
]
}
]
}
Version history
Current version v1, edited by AWS on 2026-09-04. Version history is recorded from 2026-11-11. Earlier versions are in the IAM console under Policy versions.
Attach snippets
AWS CLI
aws iam attach-role-policy --role-name ROLE_NAME --policy-arn arn:aws:iam::aws:policy/job-function/AmazonODBAutonomousDatabaseAdmin
aws iam attach-user-policy --user-name USER_NAME --policy-arn arn:aws:iam::aws:policy/job-function/AmazonODBAutonomousDatabaseAdmin
aws iam attach-group-policy --group-name GROUP_NAME --policy-arn arn:aws:iam::aws:policy/job-function/AmazonODBAutonomousDatabaseAdminCloudFormation
Resources:
ExampleRole:
Type: AWS::IAM::Role
Properties:
AssumeRolePolicyDocument: {} # replace with your trust policy
ManagedPolicyArns:
- arn:aws:iam::aws:policy/job-function/AmazonODBAutonomousDatabaseAdminTerraform
resource "aws_iam_role_policy_attachment" "job_function_amazonodbautonomousdatabaseadmin" {
role = aws_iam_role.example.name
policy_arn = "arn:aws:iam::aws:policy/job-function/AmazonODBAutonomousDatabaseAdmin"
}CDK (TypeScript)
role.addManagedPolicy(
iam.ManagedPolicy.fromAwsManagedPolicyName("job-function/AmazonODBAutonomousDatabaseAdmin"),
);Sources
- AmazonODBAutonomousDatabaseAdmin (AWS Managed Policy Reference Guide) (retrieved ; supports summary, practicalScope, securityConsiderations, assignmentGuidance, faqs)
- AWS managed policies for Oracle Database@AWS (retrieved ; supports summary, useCases, prerequisites, assignmentGuidance, faqs, securityConsiderations)
- Managed policies and inline policies (IAM User Guide) (retrieved ; supports securityConsiderations, faqs)
- AWS managed policies for job functions (IAM User Guide) (retrieved ; supports bestPractices, faqs)