Skip to main content
IAM Policy Map

AmazonRDSFullAccess

AdminAWS managedActiveReviewedShow on mapCompare

Summary

Provides full access to Amazon RDS via the AWS Management Console. The Amazon RDS User Guide says it also lets principals describe and manage Application Auto Scaling, manage CloudWatch alarms, get Performance Insights metrics and publish Amazon SNS messages.

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

Identity

ARN
arn:aws:iam::aws:policy/AmazonRDSFullAccess
Default version
v14
Created
Last edited
Services
application-autoscaling, cloudwatch, devops-guru, ec2, iam, logs, outposts, pi, rds, sns

Control-plane actions (219)

By access level: 67 List, 1 Permissions management, 20 Read, 4 Tagging, 127 Write.

Control-plane actions by service
ServiceGrantedAccess levels and limitsGranted by
Application Auto Scaling7 of 143 Read, 4 Write; 0 restricted, 0 conditionalapplication-autoscaling:DeleteScalingPolicy, application-autoscaling:DeregisterScalableTarget, application-autoscaling:DescribeScalableTargets, application-autoscaling:DescribeScalingActivities, application-autoscaling:DescribeScalingPolicies, application-autoscaling:PutScalingPolicy, application-autoscaling:RegisterScalableTarget
CloudWatch3 of 1601 Read, 2 Write; 0 restricted, 0 conditionalcloudwatch:DeleteAlarms, cloudwatch:DescribeAlarms, cloudwatch:PutMetricAlarm
DevOps Guru3 of 312 List, 1 Read; 2 restricted, 2 conditionaldevops-guru:GetResourceCollection, devops-guru:ListAnomaliesForInsight, devops-guru:SearchInsights
EC213 of 83412 List, 1 Read; 0 restricted, 0 conditionalec2:DescribeAccountAttributes, ec2:DescribeAvailabilityZones, ec2:DescribeCoipPools, ec2:DescribeInternetGateways, ec2:DescribeLocalGatewayRouteTablePermissions, ec2:DescribeLocalGatewayRouteTableVpcAssociations, ec2:DescribeLocalGatewayRouteTables, ec2:DescribeLocalGateways, ec2:DescribeSecurityGroups, ec2:DescribeSubnets, ec2:DescribeVpcAttribute, ec2:DescribeVpcs and 1 more
IAM1 of 1901 Write; 1 restricted, 1 conditionaliam:CreateServiceLinkedRole
CloudWatch Logs2 of 1331 List, 1 Read; 0 restricted, 0 conditionallogs:DescribeLogStreams, logs:GetLogEvents
Outposts1 of 441 Read; 0 restricted, 0 conditionaloutposts:GetOutpostInstanceTypes
Performance InsightsAll 14 actions (see the Performance Insights page)3 List, 7 Read, 2 Tagging, 2 Write; 14 restricted, 0 conditionalpi:*
RDSAll 173 actions (see the RDS page)47 List, 1 Permissions management, 5 Read, 2 Tagging, 118 Write; 0 restricted, 0 conditionalrds:*
SNS2 of 402 List; 0 restricted, 0 conditionalsns:ListSubscriptions, sns:ListTopics
Application Auto Scaling: 7 actions
  • application-autoscaling:DeleteScalingPolicy (Write)
  • application-autoscaling:DeregisterScalableTarget (Write)
  • application-autoscaling:DescribeScalableTargets (Read)
  • application-autoscaling:DescribeScalingActivities (Read)
  • application-autoscaling:DescribeScalingPolicies (Read)
  • application-autoscaling:PutScalingPolicy (Write)
  • application-autoscaling:RegisterScalableTarget (Write)
CloudWatch: 3 actions
  • cloudwatch:DeleteAlarms (Write)
  • cloudwatch:DescribeAlarms (Read)
  • cloudwatch:PutMetricAlarm (Write)
DevOps Guru: 3 actions
  • devops-guru:GetResourceCollection (Read)
  • devops-guru:ListAnomaliesForInsight (List)
  • devops-guru:SearchInsights (List)
EC2: 13 actions
  • ec2:DescribeAccountAttributes (List)
  • ec2:DescribeAvailabilityZones (List)
  • ec2:DescribeCoipPools (List)
  • ec2:DescribeInternetGateways (List)
  • ec2:DescribeLocalGatewayRouteTablePermissions (List)
  • ec2:DescribeLocalGatewayRouteTableVpcAssociations (List)
  • ec2:DescribeLocalGatewayRouteTables (List)
  • ec2:DescribeLocalGateways (List)
  • ec2:DescribeSecurityGroups (List)
  • ec2:DescribeSubnets (List)
  • ec2:DescribeVpcAttribute (List)
  • ec2:DescribeVpcs (List)
  • ec2:GetCoipPoolUsage (Read)
IAM: 1 actions
  • iam:CreateServiceLinkedRole (Write)
CloudWatch Logs: 2 actions
  • logs:DescribeLogStreams (List)
  • logs:GetLogEvents (Read)
Outposts: 1 actions
  • outposts:GetOutpostInstanceTypes (Read)
SNS: 2 actions
  • sns:ListSubscriptions (List)
  • sns:ListTopics (List)

Data-plane actions (4)

By access level: 1 List, 2 Read, 1 Write.

Data-plane actions by service
ServiceGrantedAccess levels and limitsGranted by
CloudWatch3 of 51 List, 2 Read; 0 restricted, 0 conditionalcloudwatch:GetMetricData, cloudwatch:GetMetricStatistics, cloudwatch:ListMetrics
SNSAll 1 actions (see the SNS page)1 Write; 0 restricted, 0 conditionalsns:Publish
CloudWatch: 3 actions
  • cloudwatch:GetMetricData (Read)
  • cloudwatch:GetMetricStatistics (Read)
  • cloudwatch:ListMetrics (List)

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 (119 of 119).
  • 2 granted write or permissions-management actions have no data-plane classification from AWS, so the data-plane rule cannot assess them.

Guidance

Practical scope

The first statement allows rds:* plus actions for Application Auto Scaling, CloudWatch alarms and metrics, Amazon EC2 describe actions, sns:ListSubscriptions, sns:ListTopics, sns:Publish, CloudWatch Logs reads, outposts:GetOutpostInstanceTypes and devops-guru:GetResourceCollection, on Resource "*". A second statement allows pi:* on arn:aws:pi:*:*:metrics/rds/* and arn:aws:pi:*:*:perf-reports/rds/*. iam:CreateServiceLinkedRole is allowed for rds.amazonaws.com and rds.application-autoscaling.amazonaws.com. Two DevOps Guru actions are allowed only for the RDS service name.

Use cases

  • Give users, groups or roles full access to Amazon RDS through the console.

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

  • rds:* allows every Amazon RDS action on all resources. The policy also allows sns:Publish and CloudWatch alarm changes (cloudwatch:PutMetricAlarm, cloudwatch:DeleteAlarms) on all resources.
  • 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 Amazon RDS User Guide says it provides full access to Amazon RDS through the AWS Management Console. It fits where full access to Amazon RDS is intended.

Same service

Same domain

Frequently asked questions

When should I attach AmazonRDSFullAccess?
The Amazon RDS User Guide says it provides full access to Amazon RDS through the AWS Management Console. Attach it where that is the intended scope.
What does AmazonRDSFullAccess grant?
It allows rds:* on all resources, plus Application Auto Scaling, CloudWatch alarm and metric actions, Amazon EC2 describe actions, Amazon SNS list and publish actions, CloudWatch Logs reads, Performance Insights (pi:*) on RDS metrics and reports, and service-linked role creation for RDS.
What are the security risks of AmazonRDSFullAccess?
rds:* allows every Amazon RDS action on all resources, and the policy also allows sns:Publish and CloudWatch alarm changes. AWS managed policies don't grant least privilege permissions, and you must consider the security risk of granting principals more permissions than they need. AWS updates to the policy affect every identity it is attached to.

Policy JSON

Download policy.json

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Action": [
        "rds:*",
        "application-autoscaling:DeleteScalingPolicy",
        "application-autoscaling:DeregisterScalableTarget",
        "application-autoscaling:DescribeScalableTargets",
        "application-autoscaling:DescribeScalingActivities",
        "application-autoscaling:DescribeScalingPolicies",
        "application-autoscaling:PutScalingPolicy",
        "application-autoscaling:RegisterScalableTarget",
        "cloudwatch:DescribeAlarms",
        "cloudwatch:GetMetricStatistics",
        "cloudwatch:PutMetricAlarm",
        "cloudwatch:DeleteAlarms",
        "cloudwatch:ListMetrics",
        "cloudwatch:GetMetricData",
        "ec2:DescribeAccountAttributes",
        "ec2:DescribeAvailabilityZones",
        "ec2:DescribeCoipPools",
        "ec2:DescribeInternetGateways",
        "ec2:DescribeLocalGatewayRouteTablePermissions",
        "ec2:DescribeLocalGatewayRouteTables",
        "ec2:DescribeLocalGatewayRouteTableVpcAssociations",
        "ec2:DescribeLocalGateways",
        "ec2:DescribeSecurityGroups",
        "ec2:DescribeSubnets",
        "ec2:DescribeVpcAttribute",
        "ec2:DescribeVpcs",
        "ec2:GetCoipPoolUsage",
        "sns:ListSubscriptions",
        "sns:ListTopics",
        "sns:Publish",
        "logs:DescribeLogStreams",
        "logs:GetLogEvents",
        "outposts:GetOutpostInstanceTypes",
        "devops-guru:GetResourceCollection"
      ],
      "Resource": "*"
    },
    {
      "Effect": "Allow",
      "Action": "pi:*",
      "Resource": [
        "arn:aws:pi:*:*:metrics/rds/*",
        "arn:aws:pi:*:*:perf-reports/rds/*"
      ]
    },
    {
      "Effect": "Allow",
      "Action": "iam:CreateServiceLinkedRole",
      "Resource": "*",
      "Condition": {
        "StringLike": {
          "iam:AWSServiceName": [
            "rds.amazonaws.com",
            "rds.application-autoscaling.amazonaws.com"
          ]
        }
      }
    },
    {
      "Action": [
        "devops-guru:SearchInsights",
        "devops-guru:ListAnomaliesForInsight"
      ],
      "Effect": "Allow",
      "Resource": "*",
      "Condition": {
        "ForAllValues:StringEquals": {
          "devops-guru:ServiceNames": [
            "RDS"
          ]
        },
        "Null": {
          "devops-guru:ServiceNames": "false"
        }
      }
    }
  ]
}

Version history

Current version v14, edited by AWS on 2023-08-17. 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/AmazonRDSFullAccess
aws iam attach-user-policy --user-name USER_NAME --policy-arn arn:aws:iam::aws:policy/AmazonRDSFullAccess
aws iam attach-group-policy --group-name GROUP_NAME --policy-arn arn:aws:iam::aws:policy/AmazonRDSFullAccess

CloudFormation

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

Terraform

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

CDK (TypeScript)

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

Sources