AWS managed policies for Amazon RDS

To add permissions to permission sets and roles, it's easier to use AWS managed policies than to write policies yourself. It takes time and expertise to create IAM customer managed policies that provide your team with only the permissions they need. To get started quickly, you can use our AWS managed policies. These policies cover common use cases and are available in your AWS account. For more information about AWS managed policies, see AWS managed policies in the IAM User Guide.

AWS services maintain and update AWS managed policies. You can't change the permissions in AWS managed policies. Services occasionally add additional permissions to an AWS managed policy to support new features. This type of update affects all identities (permission sets and roles) where the policy is attached. Services are most likely to update an AWS managed policy when a new feature is launched or when new operations become available. Services don't remove permissions from an AWS managed policy, so policy updates don't break your existing permissions.

Additionally, AWS supports managed policies for job functions that span multiple services. For example, the ReadOnlyAccess AWS managed policy provides read-only access to all AWS services and resources. When a service launches a new feature, AWS adds read-only permissions for new operations and resources. For a list and descriptions of job function policies, see AWS managed policies for job functions in the IAM User Guide.

AWS managed policy: AmazonRDSReadOnlyAccess

This policy allows read-only access to Amazon RDS through the AWS Management Console.

Permissions details

This policy includes the following permissions:

• rds – Allows principals to describe Amazon RDS resources and list the tags for Amazon RDS resources.

• cloudwatch – Allows principals to get Amazon CloudWatch metric statistics.

• ec2 – Allows principals to describe Availability Zones and networking resources.

• logs – Allows principals to describe CloudWatch Logs log streams of log groups, and get CloudWatch Logs log events.

• devops-guru – Allows principals to describe resources that have Amazon DevOps Guru coverage, which is specified either by CloudFormation stack names or resource tags.

For more information about this policy, including the JSON policy document, see AmazonRDSReadOnlyAccess in the AWS Managed Policy Reference Guide.

AWS managed policy: AmazonRDSFullAccess

This policy provides full access to Amazon RDS through the AWS Management Console.

Permissions details

This policy includes the following permissions:

• rds – Allows principals full access to Amazon RDS.

• application-autoscaling – Allows principals describe and manage Application Auto Scaling scaling targets and policies.

• cloudwatch – Allows principals get CloudWatch metric statics and manage CloudWatch alarms.

• ec2 – Allows principals to describe Availability Zones and networking resources.

• logs – Allows principals to describe CloudWatch Logs log streams of log groups, and get CloudWatch Logs log events.

• outposts – Allows principals to get AWS Outposts instance types.

• pi – Allows principals to get Performance Insights metrics.

• sns – Allows principals to Amazon Simple Notification Service (Amazon SNS) subscriptions and topics, and to publish Amazon SNS messages.

• devops-guru – Allows principals to describe resources that have Amazon DevOps Guru coverage, which is specified either by CloudFormation stack names or resource tags.

For more information about this policy, including the JSON policy document, see AmazonRDSFullAccess in the AWS Managed Policy Reference Guide.

AWS managed policy: AmazonRDSDataFullAccess

This policy allows full access to use the Data API and the query editor on Aurora Serverless clusters in a specific AWS account. This policy allows the AWS account to get the value of a secret from AWS Secrets Manager.

You can attach the AmazonRDSDataFullAccess policy to your IAM identities.

Permissions details

This policy includes the following permissions:

• dbqms – Allows principals to access, create, delete, describe, and update queries. The Database Query Metadata Service (dbqms) is an internal-only service. It provides your recent and saved queries for the query editor on the AWS Management Console for multiple AWS services, including Amazon RDS.

• rds-data – Allows principals to run SQL statements on Aurora Serverless databases.

• secretsmanager – Allows principals to get the value of a secret from AWS Secrets Manager.

For more information about this policy, including the JSON policy document, see AmazonRDSDataFullAccess in the AWS Managed Policy Reference Guide.

AWS managed policy: AmazonRDSEnhancedMonitoringRole

This policy provides access to Amazon CloudWatch Logs for Amazon RDS Enhanced Monitoring.

Permissions details

This policy includes the following permissions:

• logs – Allows principals to create CloudWatch Logs log groups and retention policies, and to create and describe CloudWatch Logs log streams of log groups. It also allows principals to put and get CloudWatch Logs log events.

For more information about this policy, including the JSON policy document, see AmazonRDSEnhancedMonitoringRole in the AWS Managed Policy Reference Guide.

AWS managed policy: AmazonRDSPerformanceInsightsReadOnly

This policy provides read-only access to Amazon RDS Performance Insights for Amazon RDS DB instances and Amazon Aurora DB clusters.

This policy now includes Sid (statement ID) as an identifier for the policy statement.

Permissions details

This policy includes the following permissions:

• rds – Allows principals to describe Amazon RDS DB instances and Amazon Aurora DB clusters.

• pi – Allows principals make calls to the Amazon RDS Performance Insights API and access Performance Insights metrics.

For more information about this policy, including the JSON policy document, see AmazonRDSPerformanceInsightsReadOnly in the AWS Managed Policy Reference Guide.

AWS managed policy: AmazonRDSPerformanceInsightsFullAccess

This policy provides full access to Amazon RDS Performance Insights for Amazon RDS DB instances and Amazon Aurora DB clusters.

This policy now includes Sid (statement ID) as an identifier for the policy statement.

Permissions details

This policy includes the following permissions:

• rds – Allows principals to describe Amazon RDS DB instances and Amazon Aurora DB clusters.

• pi – Allows principals make calls to the Amazon RDS Performance Insights API, and create, view, and delete performance analysis reports.

• cloudwatch – Allows principals to list all the Amazon CloudWatch metrics, and get metric data and statistics.

For more information about this policy, including the JSON policy document, see AmazonRDSPerformanceInsightsFullAccess in the AWS Managed Policy Reference Guide.

AWS managed policy: AmazonRDSDirectoryServiceAccess

This policy allows Amazon RDS to make calls to the AWS Directory Service.

Permissions details

This policy includes the following permission:

• ds – Allows principals to describe AWS Directory Service directories and control authorization to AWS Directory Service directories.

For more information about this policy, including the JSON policy document, see AmazonRDSDirectoryServiceAccess in the AWS Managed Policy Reference Guide.

AWS managed policy: AmazonRDSServiceRolePolicy

You can't attach the AmazonRDSServiceRolePolicy policy to your IAM entities. This policy is attached to a service-linked role that allows Amazon RDS to perform actions on your behalf. For more information, see Service-linked role permissions for Amazon Aurora.

AWS managed policy: AmazonRDSPreviewServiceRolePolicy

You shouldn't attach AmazonRDSPreviewServiceRolePolicy to your IAM entities. This policy is attached to a service-linked role that allows Amazon RDS to call AWS services on behalf of your RDS DB resources. For more information, see Service-linked role for Amazon RDS Preview.

Permissions details

This policy includes the following permissions:

• ec2 ‐ Allows principals to describe Availability Zones and networking resources.

• secretsmanager – Allows principals to get the value of a secret from AWS Secrets Manager.

• cloudwatch, logs ‐ Allows Amazon RDS to upload DB instance metrics and logs to CloudWatch through CloudWatch agent.

For more information about this policy, including the JSON policy document, see AmazonRDSDataFullAccess in the AWS Managed Policy Reference Guide.

AWS managed policy: AmazonRDSBetaServiceRolePolicy

You shouldn't attach AmazonRDSBetaServiceRolePolicy to your IAM entities. This policy is attached to a service-linked role that allows Amazon RDS to call AWS services on behalf of your RDS DB resources. For more information, see Service-linked role permissions for Amazon RDS Beta.

Permissions details

This policy includes the following permissions:

• ec2 ‐ Allows Amazon RDS to perform backup operations on the DB instance that provides point-in-time restore capabilities.

• secretsmanager ‐ Allows Amazon RDS to manage DB instance specific secrets created by Amazon RDS.

• cloudwatch, logs ‐ Allows Amazon RDS to upload DB instance metrics and logs to CloudWatch through CloudWatch agent.

For more information about this policy, including the JSON policy document, see AmazonRDSBetaServiceRolePolicy in the AWS Managed Policy Reference Guide.