AmazonRedshiftQueryEditorV2FullAccess

Last Modified

Mar 12, 2026

March 12, 2026 at 09:28 PM UTC

Version

Total Versions

Created

Feb 21, 2024

Actions

Subscribe to updates

Risk

Medium

The same capabilities in a scoped form, resource policy writes, reads across all data, or full access to a whole service. Read from this policy document alone: trust policies, boundaries and SCPs in your account still decide what actually succeeds. How this is assessed

Medium
Full sqlworkbench access on every resource
Uses sqlworkbench:* with Resource "*" and no condition, so every action AWS adds to that service later is granted too.
sqlworkbench:*
Use with caution: The grant grows every time the service does. For long-lived access, prefer a policy that lists the actions you actually need.

Policy Document

View on GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61{
  "PolicyVersion": {
    "Document": {
      "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": "*"
        }
      ]
    },
    "VersionId": "v3",
    "IsDefaultVersion": true,
    "CreateDate": "2024-02-21T17:20:52+00:00"
  }
}