AWS Managed Policies. A maze of twisty passages all alike. Explore them here. If it looks like a button, it's clickable. Always up to date.

AmazonRedshiftQueryEditorV2FullAccess details (in AWS console)

Policy Name

AmazonRedshiftQueryEditorV2FullAccess

Description

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.

ARN

arn:aws:iam::aws:policy/AmazonRedshiftQueryEditorV2FullAccess

Path

PolicyId

ANPAZKAPJZG4BKYFZHR4E

AttachmentCount

redshift redshift-serverless kms secretsmanager tag sqlworkbench

[
  {
    "Effect": "Allow",
    "Action": [
      "redshift:DescribeClusters",
      "redshift-serverless:ListNamespaces",
      "redshift-serverless:ListWorkgroups"
    ],
    "Resource": [
      "*"
    ]
  },
  {
    "Effect": "Allow",
    "Action": [
      "kms:DescribeKey",
      "kms:ListAliases"
    ],
    "Resource": [
      "*"
    ]
  },
  {
    "Effect": "Allow",
    "Action": [
      "secretsmanager:CreateSecret",
      "secretsmanager:GetSecretValue",
      "secretsmanager:DeleteSecret",
      "secretsmanager:TagResource"
    ],
    "Resource": [
      "arn:aws:secretsmanager:*:*:sqlworkbench!*"
    ]
  },
  {
    "Effect": "Allow",
    "Action": [
      "tag:GetResources"
    ],
    "Resource": [
      "*"
    ]
  },
  {
    "Effect": "Allow",
    "Action": [
      "sqlworkbench:*"
    ],
    "Resource": [
      "*"
    ]
  }
]