AmazonRedshiftQueryEditorV2FullAccess

Summary

Grants full access to the Amazon Redshift Query Editor V2 operations and resources. This policy also grants access to other required services. This includes permissions to list the Amazon Redshift clusters, read keys and aliases in AWS KMS and manage the Query Editor V2 secrets in AWS Secrets Manager.

Permissions imported from the AWS Managed Policy Reference Guide; other sections pending editorial review.

Identity

ARN

arn:aws:iam::aws:policy/AmazonRedshiftQueryEditorV2FullAccessCopy ARN

Default version

v3

Created

2021-09-24

Last edited

2024-02-21

Services

kms, redshift, redshift-serverless, secretsmanager, sqlworkbench, tag

Control-plane actions (89)

By access level: 13 List, 26 Read, 3 Tagging, 47 Write.

Data-plane actions (0)

By access level: none.

This policy grants no actions in this plane.

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: sqlworkbench (45 of 45).

Guidance

Pending editorial review. The permission data on this page comes straight from AWS; this section will be filled in once a reviewed guide exists.

Related policies

Same service

• AmazonDataZoneEnvironmentRolePermissionsBoundary
• AmazonDataZoneProjectRolePermissionsBoundary
• AmazonRedshiftQueryEditorV2NoSharing
• AmazonRedshiftQueryEditorV2ReadSharing
• AmazonRedshiftQueryEditorV2ReadWriteSharing
• SageMakerStudioBedrockKnowledgeBaseServiceRolePolicy

Same domain

• AmazonAuroraDSQLConsoleFullAccess
• AmazonAuroraDSQLFullAccess
• AmazonAuroraDSQLReadOnlyAccess
• AmazonDocDBConsoleFullAccess
• AmazonDocDBElasticFullAccess
• AmazonDocDBElasticReadOnlyAccess
• AmazonDocDBFullAccess
• AmazonDocDBReadOnlyAccess

Frequently asked questions

Pending editorial review. The permission data on this page comes straight from AWS; this section will be filled in once a reviewed guide exists.

Policy JSON

Download policy.json

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "RedshiftPermissions",
      "Effect": "Allow",
      "Action": [
        "redshift:DescribeClusters",
        "redshift-serverless:ListNamespaces",
        "redshift-serverless:ListWorkgroups"
      ],
      "Resource": "*"
    },
    {
      "Sid": "KeyManagementServicePermissions",
      "Effect": "Allow",
      "Action": [
        "kms:DescribeKey",
        "kms:ListAliases"
      ],
      "Resource": "*"
    },
    {
      "Sid": "SecretsManagerPermissions",
      "Effect": "Allow",
      "Action": [
        "secretsmanager:CreateSecret",
        "secretsmanager:GetSecretValue",
        "secretsmanager:DeleteSecret",
        "secretsmanager:TagResource"
      ],
      "Resource": "arn:aws:secretsmanager:*:*:sqlworkbench!*"
    },
    {
      "Sid": "ResourceGroupsTaggingPermissions",
      "Effect": "Allow",
      "Action": [
        "tag:GetResources"
      ],
      "Resource": "*",
      "Condition": {
        "StringEquals": {
          "aws:CalledViaLast": "sqlworkbench.amazonaws.com"
        }
      }
    },
    {
      "Sid": "AmazonRedshiftQueryEditorV2Permissions",
      "Effect": "Allow",
      "Action": "sqlworkbench:*",
      "Resource": "*"
    }
  ]
}

Version history

Current version v3, edited by AWS on 2024-02-21. 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/AmazonRedshiftQueryEditorV2FullAccess
aws iam attach-user-policy --user-name USER_NAME --policy-arn arn:aws:iam::aws:policy/AmazonRedshiftQueryEditorV2FullAccess
aws iam attach-group-policy --group-name GROUP_NAME --policy-arn arn:aws:iam::aws:policy/AmazonRedshiftQueryEditorV2FullAccess

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

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

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

Sources

Pending editorial review. No editorial sources are listed yet.

• Official AWS reference for AmazonRedshiftQueryEditorV2FullAccess
• Report a data issue