AmazonRDSFullAccess
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.
| Service | Granted | Access levels and limits | Granted by |
|---|---|---|---|
| Application Auto Scaling | 7 of 14 | 3 Read, 4 Write; 0 restricted, 0 conditional | application-autoscaling:DeleteScalingPolicy, application-autoscaling:DeregisterScalableTarget, application-autoscaling:DescribeScalableTargets, application-autoscaling:DescribeScalingActivities, application-autoscaling:DescribeScalingPolicies, application-autoscaling:PutScalingPolicy, application-autoscaling:RegisterScalableTarget |
| CloudWatch | 3 of 160 | 1 Read, 2 Write; 0 restricted, 0 conditional | cloudwatch:DeleteAlarms, cloudwatch:DescribeAlarms, cloudwatch:PutMetricAlarm |
| DevOps Guru | 3 of 31 | 2 List, 1 Read; 2 restricted, 2 conditional | devops-guru:GetResourceCollection, devops-guru:ListAnomaliesForInsight, devops-guru:SearchInsights |
| EC2 | 13 of 834 | 12 List, 1 Read; 0 restricted, 0 conditional | ec2: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 |
| IAM | 1 of 190 | 1 Write; 1 restricted, 1 conditional | iam:CreateServiceLinkedRole |
| CloudWatch Logs | 2 of 133 | 1 List, 1 Read; 0 restricted, 0 conditional | logs:DescribeLogStreams, logs:GetLogEvents |
| Outposts | 1 of 44 | 1 Read; 0 restricted, 0 conditional | outposts:GetOutpostInstanceTypes |
| Performance Insights | All 14 actions (see the Performance Insights page) | 3 List, 7 Read, 2 Tagging, 2 Write; 14 restricted, 0 conditional | pi:* |
| RDS | All 173 actions (see the RDS page) | 47 List, 1 Permissions management, 5 Read, 2 Tagging, 118 Write; 0 restricted, 0 conditional | rds:* |
| SNS | 2 of 40 | 2 List; 0 restricted, 0 conditional | sns: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.
| Service | Granted | Access levels and limits | Granted by |
|---|---|---|---|
| CloudWatch | 3 of 5 | 1 List, 2 Read; 0 restricted, 0 conditional | cloudwatch:GetMetricData, cloudwatch:GetMetricStatistics, cloudwatch:ListMetrics |
| SNS | All 1 actions (see the SNS page) | 1 Write; 0 restricted, 0 conditional | sns: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.
Related policies
Same service
- AmazonAppStreamFullAccess
- AmazonDocDBConsoleFullAccess
- AmazonDocDBFullAccess
- AmazonDocDBReadOnlyAccess
- AmazonDynamoDBFullAccess
- AmazonDynamoDBFullAccess_v2
- AmazonECS_FullAccess
- AmazonECSInfrastructureRoleforExpressGatewayServices
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
{
"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/AmazonRDSFullAccessCloudFormation
Resources:
ExampleRole:
Type: AWS::IAM::Role
Properties:
AssumeRolePolicyDocument: {} # replace with your trust policy
ManagedPolicyArns:
- arn:aws:iam::aws:policy/AmazonRDSFullAccessTerraform
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
- AmazonRDSFullAccess (AWS Managed Policy Reference Guide) (retrieved ; supports summary, practicalScope, securityConsiderations, assignmentGuidance, faqs)
- Identity and access management for Amazon RDS: AWS managed policies (Amazon RDS User Guide) (retrieved ; supports summary, useCases, assignmentGuidance, faqs)
- AWS managed policies for job functions (IAM User Guide) (retrieved ; supports bestPractices, faqs)
- Managed policies and inline policies (IAM User Guide) (retrieved ; supports securityConsiderations, faqs)