AmazonRedshiftQueryEditor

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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84{
  "PolicyVersion": {
    "Document": {
      "Version": "2012-10-17",
      "Statement": [
        {
          "Effect": "Allow",
          "Action": [
            "redshift:GetClusterCredentials",
            "redshift:ListSchemas",
            "redshift:ListTables",
            "redshift:ListDatabases",
            "redshift:ExecuteQuery",
            "redshift:FetchResults",
            "redshift:CancelQuery",
            "redshift:DescribeClusters",
            "redshift:DescribeQuery",
            "redshift:DescribeTable",
            "redshift:ViewQueriesFromConsole",
            "redshift:DescribeSavedQueries",
            "redshift:CreateSavedQuery",
            "redshift:DeleteSavedQueries",
            "redshift:ModifySavedQuery"
          ],
          "Resource": "*"
        },
        {
          "Sid": "DataAPIPermissions",
          "Action": [
            "redshift-data:ExecuteStatement",
            "redshift-data:ListDatabases",
            "redshift-data:ListSchemas",
            "redshift-data:ListTables",
            "redshift-data:DescribeTable"
          ],
          "Effect": "Allow",
          "Resource": "*"
        },
        {
          "Sid": "DataAPIIAMSessionPermissionsRestriction",
          "Action": [
            "redshift-data:GetStatementResult",
            "redshift-data:CancelStatement",
            "redshift-data:DescribeStatement",
            "redshift-data:ListStatements"
          ],
          "Effect": "Allow",
          "Resource": "*",
          "Condition": {
            "StringEquals": {
              "redshift-data:statement-owner-iam-userid": "${aws:userid}"
            }
          }
        },
        {
          "Sid": "SecretsManagerListPermissions",
          "Action": [
            "secretsmanager:ListSecrets"
          ],
          "Effect": "Allow",
          "Resource": "*"
        },
        {
          "Sid": "SecretsManagerCreateGetPermissions",
          "Action": [
            "secretsmanager:CreateSecret",
            "secretsmanager:GetSecretValue",
            "secretsmanager:TagResource"
          ],
          "Effect": "Allow",
          "Resource": "arn:aws:secretsmanager:*:*:secret:*",
          "Condition": {
            "StringEquals": {
              "secretsmanager:ResourceTag/RedshiftQueryOwner": "${aws:userid}"
            }
          }
        }
      ]
    },
    "VersionId": "v4",
    "IsDefaultVersion": true,
    "CreateDate": "2021-02-16T19:33:45+00:00"
  }
}