AmazonRDSDataFullAccess

Summary

Allows full access to use the RDS data APIs, the secret store APIs for RDS database credentials, and the DB console query management APIs to run SQL statements on Aurora Serverless clusters in the account. The Amazon RDS User Guide says it also allows the account to get the value of a secret from AWS Secrets Manager.

Permissions imported from the AWS Managed Policy Reference Guide; other sections reviewed against the listed AWS sources.

Identity

ARN

arn:aws:iam::aws:policy/AmazonRDSDataFullAccessCopy ARN

Default version

v3

Created

2018-11-20

Last edited

2019-11-20

Services

dbqms, rds-data, secretsmanager, tag

Control-plane actions (19)

By access level: 3 List, 1 Permissions management, 5 Read, 1 Tagging, 9 Write.

Data-plane actions (6)

By access level: 6 Write.

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 at least 80% of the write and permissions-management actions of: rds-data (6 of 6).
• Grants data-plane write actions on a data store on all resources without conditions.

Guidance

Related policies

Same service

• AlexaForBusinessDeviceSetup
• AlexaForBusinessNetworkProfileServicePolicy
• AmazonCognitoIdpServiceRolePolicy
• AmazonDataZonePreviewConsoleFullAccess
• AmazonDocDBElasticFullAccess
• AmazonECSInfrastructureRolePolicyForServiceConnectTransportLayerSecurity
• AmazonEKSLocalOutpostServiceRolePolicy
• AmazonEventBridgeApiDestinationsServiceRolePolicy

Same domain

• AdministratorAccess
• AdministratorAccess-Amplify
• AIDevOpsAgentActionsPolicy
• AmazonDataZoneProjectDeploymentPermissionsBoundary
• AmazonDynamoDBFullAccess
• AmazonDynamoDBFullAccess_v2
• AmazonDynamoDBFullAccesswithDataPipeline
• AmazonEC2RoleforDataPipelineRole

Frequently asked questions

When should I attach AmazonRDSDataFullAccess?

The Amazon RDS User Guide says you can attach it to your IAM identities to allow full access to the Data API and the query editor on Aurora Serverless clusters in the account. Attach it where that scope is intended.

What does AmazonRDSDataFullAccess grant?

It allows rds-data SQL actions and dbqms query management actions on all resources, secretsmanager read, write and delete actions on rds-db-credentials/ secrets, and secretsmanager:CreateSecret, ListSecrets and GetRandomPassword.

What are the security risks of AmazonRDSDataFullAccess?

It lets holders run SQL against Aurora Serverless databases and read, replace or delete the stored database credentials under rds-db-credentials/. AWS managed policies do not grant least privilege permissions, and an AWS update to the policy affects every identity it is attached to.

Policy JSON

Download policy.json

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "SecretsManagerDbCredentialsAccess",
      "Effect": "Allow",
      "Action": [
        "secretsmanager:GetSecretValue",
        "secretsmanager:PutResourcePolicy",
        "secretsmanager:PutSecretValue",
        "secretsmanager:DeleteSecret",
        "secretsmanager:DescribeSecret",
        "secretsmanager:TagResource"
      ],
      "Resource": "arn:aws:secretsmanager:*:*:secret:rds-db-credentials/*"
    },
    {
      "Sid": "RDSDataServiceAccess",
      "Effect": "Allow",
      "Action": [
        "dbqms:CreateFavoriteQuery",
        "dbqms:DescribeFavoriteQueries",
        "dbqms:UpdateFavoriteQuery",
        "dbqms:DeleteFavoriteQueries",
        "dbqms:GetQueryString",
        "dbqms:CreateQueryHistory",
        "dbqms:DescribeQueryHistory",
        "dbqms:UpdateQueryHistory",
        "dbqms:DeleteQueryHistory",
        "rds-data:ExecuteSql",
        "rds-data:ExecuteStatement",
        "rds-data:BatchExecuteStatement",
        "rds-data:BeginTransaction",
        "rds-data:CommitTransaction",
        "rds-data:RollbackTransaction",
        "secretsmanager:CreateSecret",
        "secretsmanager:ListSecrets",
        "secretsmanager:GetRandomPassword",
        "tag:GetResources"
      ],
      "Resource": "*"
    }
  ]
}

Version history

Current version v3, edited by AWS on 2019-11-20. Version history is recorded from 2026-11-11. Earlier versions are in the IAM console under Policy versions.

Attach snippets

aws iam attach-role-policy --role-name ROLE_NAME --policy-arn arn:aws:iam::aws:policy/AmazonRDSDataFullAccess
aws iam attach-user-policy --user-name USER_NAME --policy-arn arn:aws:iam::aws:policy/AmazonRDSDataFullAccess
aws iam attach-group-policy --group-name GROUP_NAME --policy-arn arn:aws:iam::aws:policy/AmazonRDSDataFullAccess

Resources:
  ExampleRole:
    Type: AWS::IAM::Role
    Properties:
      AssumeRolePolicyDocument: {}  # replace with your trust policy
      ManagedPolicyArns:
        - arn:aws:iam::aws:policy/AmazonRDSDataFullAccess

resource "aws_iam_role_policy_attachment" "amazonrdsdatafullaccess" {
  role       = aws_iam_role.example.name
  policy_arn = "arn:aws:iam::aws:policy/AmazonRDSDataFullAccess"
}

role.addManagedPolicy(
  iam.ManagedPolicy.fromAwsManagedPolicyName("AmazonRDSDataFullAccess"),
);

Sources

• AmazonRDSDataFullAccess (AWS Managed Policy Reference Guide) (retrieved 2026-11-13; supports summary, practicalScope, useCases, securityConsiderations, assignmentGuidance, faqs)
• Identity and access management for Amazon RDS: AWS managed policies (Amazon RDS User Guide) (retrieved 2026-11-12; supports summary, useCases, securityConsiderations, assignmentGuidance, faqs)
• AWS managed policies for job functions (IAM User Guide) (retrieved 2026-11-12; supports bestPractices, faqs)
• Managed policies and inline policies (IAM User Guide) (retrieved 2026-11-12; supports securityConsiderations, faqs)

• Official AWS reference for AmazonRDSDataFullAccess
• AWS service guide
• Report a data issue