AmazonRDSReadOnlyAccess
Summary
Provides read only access to Amazon RDS via the AWS Management Console. The Amazon RDS User Guide says it allows principals to describe Amazon RDS resources and list their tags, and to read related CloudWatch, Amazon EC2, CloudWatch Logs and DevOps Guru information.
Permissions imported from the AWS Managed Policy Reference Guide; other sections reviewed against the listed AWS sources.
Identity
- ARN
arn:aws:iam::aws:policy/AmazonRDSReadOnlyAccess- Default version
- v7
- Created
- Last edited
- Services
- cloudwatch, devops-guru, ec2, logs, rds
Control-plane actions (62)
By access level: 57 List, 5 Read.
| Service | Granted | Access levels and limits | Granted by |
|---|---|---|---|
| DevOps Guru | 3 of 31 | 2 List, 1 Read; 2 restricted, 2 conditional | devops-guru:GetResourceCollection, devops-guru:ListAnomaliesForInsight, devops-guru:SearchInsights |
| EC2 | 7 of 834 | 7 List; 0 restricted, 0 conditional | ec2:DescribeAccountAttributes, ec2:DescribeAvailabilityZones, ec2:DescribeInternetGateways, ec2:DescribeSecurityGroups, ec2:DescribeSubnets, ec2:DescribeVpcAttribute, ec2:DescribeVpcs |
| CloudWatch Logs | 2 of 133 | 1 List, 1 Read; 0 restricted, 0 conditional | logs:DescribeLogStreams, logs:GetLogEvents |
| RDS | 50 of 173 | 47 List, 3 Read; 0 restricted, 0 conditional | rds:Describe*, rds:ListTagsForResource |
DevOps Guru: 3 actions
- devops-guru:GetResourceCollection (Read)
- devops-guru:ListAnomaliesForInsight (List)
- devops-guru:SearchInsights (List)
EC2: 7 actions
- ec2:DescribeAccountAttributes (List)
- ec2:DescribeAvailabilityZones (List)
- ec2:DescribeInternetGateways (List)
- ec2:DescribeSecurityGroups (List)
- ec2:DescribeSubnets (List)
- ec2:DescribeVpcAttribute (List)
- ec2:DescribeVpcs (List)
CloudWatch Logs: 2 actions
- logs:DescribeLogStreams (List)
- logs:GetLogEvents (Read)
RDS: 50 actions
- rds:DescribeAccountAttributes (List)
- rds:DescribeBlueGreenDeployments (List)
- rds:DescribeCertificates (List)
- rds:DescribeDBCapacityReservations (List)
- rds:DescribeDBClusterAutomatedBackups (List)
- rds:DescribeDBClusterBacktracks (List)
- rds:DescribeDBClusterEndpoints (List)
- rds:DescribeDBClusterParameterGroups (List)
- rds:DescribeDBClusterParameters (List)
- rds:DescribeDBClusterSnapshotAttributes (List)
- rds:DescribeDBClusterSnapshots (List)
- rds:DescribeDBClusters (List)
- rds:DescribeDBEngineVersions (List)
- rds:DescribeDBInstanceAutomatedBackups (List)
- rds:DescribeDBInstances (List)
- rds:DescribeDBLogFiles (List)
- rds:DescribeDBMajorEngineVersions (List)
- rds:DescribeDBParameterGroups (List)
- rds:DescribeDBParameters (List)
- rds:DescribeDBProxies (List)
- rds:DescribeDBProxyEndpoints (List)
- rds:DescribeDBProxyTargetGroups (List)
- rds:DescribeDBProxyTargets (List)
- rds:DescribeDBRecommendations (List)
- rds:DescribeDBSecurityGroups (List)
- rds:DescribeDBShardGroups (List)
- rds:DescribeDBSnapshotAttributes (List)
- rds:DescribeDBSnapshotTenantDatabases (List)
- rds:DescribeDBSnapshots (List)
- rds:DescribeDBSubnetGroups (List)
- rds:DescribeEngineDefaultClusterParameters (List)
- rds:DescribeEngineDefaultParameters (List)
- rds:DescribeEventCategories (List)
- rds:DescribeEventSubscriptions (List)
- rds:DescribeEvents (List)
- rds:DescribeExportTasks (List)
- rds:DescribeGlobalClusters (List)
- rds:DescribeIntegrations (List)
- rds:DescribeOptionGroupOptions (List)
- rds:DescribeOptionGroups (List)
- rds:DescribeOrderableDBInstanceOptions (List)
- rds:DescribePendingMaintenanceActions (List)
- rds:DescribeRecommendationGroups (Read)
- rds:DescribeRecommendations (Read)
- rds:DescribeReservedDBInstances (List)
- rds:DescribeReservedDBInstancesOfferings (List)
- rds:DescribeSourceRegions (List)
- rds:DescribeTenantDatabases (List)
- rds:DescribeValidDBInstanceModifications (List)
- rds:ListTagsForResource (Read)
Data-plane actions (3)
By access level: 1 List, 2 Read.
| 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 |
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: all-resources.
Can be attached: Yes, to users, groups and roles.
Why this tier
- Grants only List and Read actions.
Guidance
Practical scope
The first statement allows rds:Describe*, rds:ListTagsForResource and Amazon EC2 describe actions for account attributes, Availability Zones, internet gateways, security groups, subnets and VPCs, on Resource "*". The second allows cloudwatch:GetMetricStatistics, cloudwatch:ListMetrics, cloudwatch:GetMetricData, logs:DescribeLogStreams, logs:GetLogEvents and devops-guru:GetResourceCollection. The third allows devops-guru:SearchInsights and devops-guru:ListAnomaliesForInsight only for the RDS service name.
Use cases
- Give users, groups or roles read-only 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
- It lets a user read CloudWatch Logs log events (logs:GetLogEvents) on all resources, not only RDS log groups, as well as RDS metadata and metrics.
- 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 allows read-only access to Amazon RDS through the AWS Management Console. It fits where read-only access to Amazon RDS is intended.
Related policies
Same service
- AdministratorAccess-AWSElasticBeanstalk
- AIDevOpsReleaseManagementVPCPolicy
- AmazonAppStreamServiceAccess
- AmazonBioDiscoveryServiceLinkedRolePolicy
- AmazonDataZoneEnvironmentRolePermissionsBoundary
- AmazonDataZoneProjectDeploymentPermissionsBoundary
- AmazonDataZoneProjectRolePermissionsBoundary
- AmazonDataZoneSageMakerProvisioningRolePolicy
Same domain
Frequently asked questions
- When should I attach AmazonRDSReadOnlyAccess?
- The Amazon RDS User Guide says it allows read-only access to Amazon RDS through the AWS Management Console. Attach it where viewing RDS resources is the intended scope.
- What does AmazonRDSReadOnlyAccess grant?
- It allows rds:Describe* and rds:ListTagsForResource, Amazon EC2 describe actions for networking resources, CloudWatch metric reads, CloudWatch Logs log stream and event reads, and DevOps Guru reads, on all resources.
- What are the security risks of AmazonRDSReadOnlyAccess?
- It has no write actions for Amazon RDS, but logs:GetLogEvents applies to all resources, so the user can read log events beyond RDS. 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:Describe*",
"rds:ListTagsForResource",
"ec2:DescribeAccountAttributes",
"ec2:DescribeAvailabilityZones",
"ec2:DescribeInternetGateways",
"ec2:DescribeSecurityGroups",
"ec2:DescribeSubnets",
"ec2:DescribeVpcAttribute",
"ec2:DescribeVpcs"
],
"Resource": "*"
},
{
"Effect": "Allow",
"Action": [
"cloudwatch:GetMetricStatistics",
"cloudwatch:ListMetrics",
"cloudwatch:GetMetricData",
"logs:DescribeLogStreams",
"logs:GetLogEvents",
"devops-guru:GetResourceCollection"
],
"Resource": "*"
},
{
"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 v7, edited by AWS on 2023-04-14. 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/AmazonRDSReadOnlyAccess
aws iam attach-user-policy --user-name USER_NAME --policy-arn arn:aws:iam::aws:policy/AmazonRDSReadOnlyAccess
aws iam attach-group-policy --group-name GROUP_NAME --policy-arn arn:aws:iam::aws:policy/AmazonRDSReadOnlyAccessCloudFormation
Resources:
ExampleRole:
Type: AWS::IAM::Role
Properties:
AssumeRolePolicyDocument: {} # replace with your trust policy
ManagedPolicyArns:
- arn:aws:iam::aws:policy/AmazonRDSReadOnlyAccessTerraform
resource "aws_iam_role_policy_attachment" "amazonrdsreadonlyaccess" {
role = aws_iam_role.example.name
policy_arn = "arn:aws:iam::aws:policy/AmazonRDSReadOnlyAccess"
}CDK (TypeScript)
role.addManagedPolicy(
iam.ManagedPolicy.fromAwsManagedPolicyName("AmazonRDSReadOnlyAccess"),
);Sources
- AmazonRDSReadOnlyAccess (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)