AmazonAuroraDSQLConsoleFullAccess

Summary

Provides console full administrative access to Aurora DSQL. The Aurora DSQL User Guide says principals with it can create, delete and update Aurora DSQL clusters, including multi-Region clusters, and manage cluster inline policies through the AWS Management Console.

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

Identity

ARN

arn:aws:iam::aws:policy/AmazonAuroraDSQLConsoleFullAccessCopy ARN

Default version

v16

Created

2024-12-03

Last edited

2026-05-13

Services

access-analyzer, cloudwatch, dsql, ec2, iam, kinesis, kms, tag

Control-plane actions (45)

By access level: 5 List, 12 Read, 2 Tagging, 26 Write.

Data-plane actions (2)

By access level: 1 List, 1 Read.

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 at least 80% of the write and permissions-management actions of: dsql (19 of 19).
• Grants iam:PassRole, but only for scoped roles or under conditions (for example iam:PassedToService).
• 8 granted write or permissions-management actions have no data-plane classification from AWS, so the data-plane rule cannot assess them.

Guidance

Related policies

Same service

• AgentRegistryFullAccess
• AmazonAppFlowFullAccess
• AmazonAuroraDSQLFullAccess
• AmazonAuroraDSQLReadOnlyAccess
• AmazonChimeSDKMessagingServiceRolePolicy
• AmazonDataZonePreviewConsoleFullAccess
• AmazonDocDBReadOnlyAccess
• AmazonEventBridgeApiDestinationsServiceRolePolicy

Same domain

• AmazonDocDBConsoleFullAccess
• AmazonDocDBElasticFullAccess
• AmazonDocDBElasticReadOnlyAccess
• AmazonDocDBFullAccess
• AmazonDynamoDBReadOnlyAccess
• AmazonElastiCacheFullAccess
• AmazonElastiCacheReadOnlyAccess
• AmazonKeyspacesFullAccess

Frequently asked questions

When should I attach AmazonAuroraDSQLConsoleFullAccess?

The Aurora DSQL User Guide says you can attach it to your users, groups and roles. Attach it for administrators who need full administrative access to Aurora DSQL through the AWS Management Console, including creating, updating and deleting clusters.

What does AmazonAuroraDSQLConsoleFullAccess grant?

It allows dsql actions on all resources, covering clusters, cluster policies, tags, database connections, multi-Region properties, backup and restore jobs and streams. It also allows console support actions for CloudWatch metrics, tags, VPC endpoints and KMS, conditioned KMS cryptographic actions, creating the dsql.amazonaws.com service-linked role and passing roles to dsql.amazonaws.com.

What are the security risks of AmazonAuroraDSQLConsoleFullAccess?

Principals can connect to the database as any user, including the admin, and can delete clusters, cluster policies and streams on all resources. The policy allows iam:PassRole to dsql.amazonaws.com on any role. AWS managed policies might not grant least-privilege permissions, and an AWS update to the policy affects every identity it is attached to.

Policy JSON

Download policy.json

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "DsqlAllPermissions",
      "Effect": "Allow",
      "Action": [
        "dsql:PutClusterPolicy",
        "dsql:GetClusterPolicy",
        "dsql:DeleteClusterPolicy",
        "dsql:CreateCluster",
        "dsql:GetCluster",
        "dsql:UpdateCluster",
        "dsql:DeleteCluster",
        "dsql:ListClusters",
        "dsql:TagResource",
        "dsql:UntagResource",
        "dsql:ListTagsForResource",
        "dsql:DbConnectAdmin",
        "dsql:DbConnect",
        "dsql:PutMultiRegionProperties",
        "dsql:PutWitnessRegion",
        "dsql:AddPeerCluster",
        "dsql:RemovePeerCluster",
        "dsql:GetVpcEndpointServiceName",
        "dsql:StartBackupJob",
        "dsql:GetBackupJob",
        "dsql:StopBackupJob",
        "dsql:StartRestoreJob",
        "dsql:GetRestoreJob",
        "dsql:StopRestoreJob",
        "dsql:InjectError",
        "dsql:CreateStream",
        "dsql:DeleteStream",
        "dsql:GetStream",
        "dsql:ListStreams",
        "dsql:UpdateStream"
      ],
      "Resource": "*"
    },
    {
      "Sid": "DsqlConsolePermissions",
      "Effect": "Allow",
      "Action": [
        "access-analyzer:ValidatePolicy",
        "tag:GetTagKeys",
        "tag:GetTagValues",
        "cloudwatch:GetMetricData",
        "ec2:DescribeVpcEndpoints",
        "kms:ListAliases",
        "kms:DescribeKey",
        "cloudwatch:ListMetrics",
        "kinesis:DescribeStreamSummary",
        "kinesis:ListStreams"
      ],
      "Resource": "*"
    },
    {
      "Sid": "KMSCryptographicPermissions",
      "Effect": "Allow",
      "Action": [
        "kms:Decrypt",
        "kms:Encrypt",
        "kms:GenerateDataKey",
        "kms:ReEncryptTo",
        "kms:ReEncryptFrom"
      ],
      "Resource": "*",
      "Condition": {
        "StringLike": {
          "kms:ViaService": [
            "dsql.*.amazonaws.com"
          ]
        },
        "ForAnyValue:StringEquals": {
          "kms:EncryptionContextKeys": "aws:dsql:ClusterId"
        }
      }
    },
    {
      "Sid": "CreateDsqlServiceLinkedRole",
      "Effect": "Allow",
      "Action": "iam:CreateServiceLinkedRole",
      "Resource": "*",
      "Condition": {
        "StringEquals": {
          "iam:AWSServiceName": "dsql.amazonaws.com"
        }
      }
    },
    {
      "Sid": "PassRoleForChangeStreams",
      "Effect": "Allow",
      "Action": "iam:PassRole",
      "Resource": "*",
      "Condition": {
        "StringEquals": {
          "iam:PassedToService": "dsql.amazonaws.com"
        }
      }
    }
  ]
}

Version history

Current version v16, edited by AWS on 2026-05-13. Version history is recorded from 2026-11-11. Earlier versions are in the IAM console under Policy versions.

Attach snippets

aws iam attach-role-policy --role-name ROLE_NAME --policy-arn arn:aws:iam::aws:policy/AmazonAuroraDSQLConsoleFullAccess
aws iam attach-user-policy --user-name USER_NAME --policy-arn arn:aws:iam::aws:policy/AmazonAuroraDSQLConsoleFullAccess
aws iam attach-group-policy --group-name GROUP_NAME --policy-arn arn:aws:iam::aws:policy/AmazonAuroraDSQLConsoleFullAccess

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

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

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

Sources

• AmazonAuroraDSQLConsoleFullAccess (AWS Managed Policy Reference Guide) (retrieved 2026-11-13; supports summary, practicalScope, securityConsiderations, assignmentGuidance, faqs)
• AWS managed policies for Amazon Aurora DSQL (retrieved 2026-11-13; supports summary, useCases, bestPractices, securityConsiderations, faqs)
• Grant a user permissions to pass a role to an AWS service (IAM User Guide) (retrieved 2026-11-13; supports securityConsiderations)
• Managed policies and inline policies (IAM User Guide) (retrieved 2026-11-12; supports securityConsiderations, faqs)

• Official AWS reference for AmazonAuroraDSQLConsoleFullAccess
• AWS service guide
• Report a data issue