Amazon managed policies for Amazon RDS - Amazon Relational Database Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Amazon managed policies for Amazon RDS

To add permissions to permission sets and roles, it's easier to use Amazon 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 Amazon managed policies. These policies cover common use cases and are available in your Amazon Web Services account. For more information about Amazon managed policies, see Amazon managed policies in the IAM User Guide.

Amazon Web Services maintain and update Amazon managed policies. You can't change the permissions in Amazon managed policies. Services occasionally add additional permissions to an Amazon 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 Amazon managed policy when a new feature is launched or when new operations become available. Services don't remove permissions from an Amazon managed policy, so policy updates don't break your existing permissions.

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

Amazon managed policy: AmazonRDSReadOnlyAccess

This policy allows read-only access to Amazon RDS through the Amazon Web Services 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 Amazon Managed Policy Reference Guide.

Amazon managed policy: AmazonRDSFullAccess

This policy provides full access to Amazon RDS through the Amazon Web Services 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 Amazon 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 Amazon Managed Policy Reference Guide.

Amazon managed policy: AmazonRDSDataFullAccess

This policy allows full access to use the Data API and the query editor on Aurora Serverless clusters in a specific Amazon Web Services account. This policy allows the Amazon Web Services account to get the value of a secret from Amazon 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 Amazon Web Services Management Console for multiple Amazon Web 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 Amazon Secrets Manager.

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

Amazon 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 Amazon Managed Policy Reference Guide.

Amazon 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 Amazon Managed Policy Reference Guide.

Amazon 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 Amazon Managed Policy Reference Guide.

Amazon managed policy: AmazonRDSDirectoryServiceAccess

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

Permissions details

This policy includes the following permission:

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

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

Amazon 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 RDS.

Amazon managed policy: AmazonRDSCustomServiceRolePolicy

You can't attach the AmazonRDSCustomServiceRolePolicy policy to your IAM entities. This policy is attached to a service-linked role that allows Amazon RDS to call Amazon services on behalf of your RDS DB resources.

This policy includes the following permissions:

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

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

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

  • events, sqs ‐ Allows RDS Custom to send and receive status information about the DB instance.

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

Amazon managed policy: AmazonRDSCustomInstanceProfileRolePolicy

You shouldn't attach AmazonRDSCustomInstanceProfileRolePolicy to your IAM entities. It should only be attached to an instance profile role that is used to grant permissions to your Amazon RDS Custom DB instance to perform various automation actions and database management tasks. Pass the instance profile as custom-iam-instance-profile parameter during the RDS Custom instance creation and RDS Custom associates this instance profile to your DB instance.

Permissions details

This policy includes the following permissions:

  • ssm, ssmmessages, ec2messages ‐ Allows RDS Custom to communicate, execute automation and maintain agents on the DB instance through Systems Manager.

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

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

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

  • events, sqs ‐ Allows RDS Custom to send and receive status information about the DB instance.

  • kms ‐ Allows RDS Custom to use an instance-specific KMS key to perform encryption of secrets and S3 objects that RDS Custom manages.

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