AmazonRedshiftDataFullAccess

Last Modified

Mar 12, 2026

March 12, 2026 at 09:28 PM UTC

Version

Total Versions

Created

Apr 7, 2023

Actions

Subscribe to updates

Risk

no risk signal

Read from this policy document alone: trust policies, boundaries and SCPs in your account still decide what actually succeeds. How this is assessed

IAM Access Analyzer (2)

Suggestion / EQUIVALENT_TO_NULL_FALSE
We recommend replacing the key secretsmanager:ResourceTag/RedshiftDataFullAccess in the condition block of StringLike with {secretsmanager:ResourceTag/RedshiftDataFullAccess: false} to ensure better enforcement of the condition. AWS docs
Suggestion / EQUIVALENT_TO_NULL_FALSE
We recommend replacing the key aws:ResourceTag/RedshiftDataFullAccess in the condition block of StringLike with {aws:ResourceTag/RedshiftDataFullAccess: false} to ensure better enforcement of the condition. AWS docs

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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87{
  "PolicyVersion": {
    "Document": {
      "Version": "2012-10-17",
      "Statement": [
        {
          "Sid": "DataAPIPermissions",
          "Effect": "Allow",
          "Action": [
            "redshift-data:BatchExecuteStatement",
            "redshift-data:ExecuteStatement",
            "redshift-data:CancelStatement",
            "redshift-data:ListStatements",
            "redshift-data:GetStatementResult",
            "redshift-data:DescribeStatement",
            "redshift-data:ListDatabases",
            "redshift-data:ListSchemas",
            "redshift-data:ListTables",
            "redshift-data:DescribeTable"
          ],
          "Resource": "*"
        },
        {
          "Sid": "SecretsManagerPermissions",
          "Effect": "Allow",
          "Action": [
            "secretsmanager:GetSecretValue"
          ],
          "Resource": "arn:aws:secretsmanager:*:*:secret:*",
          "Condition": {
            "StringLike": {
              "secretsmanager:ResourceTag/RedshiftDataFullAccess": "*"
            }
          }
        },
        {
          "Sid": "GetCredentialsForAPIUser",
          "Effect": "Allow",
          "Action": "redshift:GetClusterCredentials",
          "Resource": [
            "arn:aws:redshift:*:*:dbname:*/*",
            "arn:aws:redshift:*:*:dbuser:*/redshift_data_api_user"
          ]
        },
        {
          "Sid": "GetCredentialsWithFederatedIAMCredentials",
          "Effect": "Allow",
          "Action": "redshift:GetClusterCredentialsWithIAM",
          "Resource": "arn:aws:redshift:*:*:dbname:*/*"
        },
        {
          "Sid": "GetCredentialsForServerless",
          "Effect": "Allow",
          "Action": "redshift-serverless:GetCredentials",
          "Resource": "arn:aws:redshift-serverless:*:*:workgroup/*",
          "Condition": {
            "StringLike": {
              "aws:ResourceTag/RedshiftDataFullAccess": "*"
            }
          }
        },
        {
          "Sid": "DenyCreateAPIUser",
          "Effect": "Deny",
          "Action": "redshift:CreateClusterUser",
          "Resource": [
            "arn:aws:redshift:*:*:dbuser:*/redshift_data_api_user"
          ]
        },
        {
          "Sid": "ServiceLinkedRole",
          "Effect": "Allow",
          "Action": "iam:CreateServiceLinkedRole",
          "Resource": "arn:aws:iam::*:role/aws-service-role/redshift-data.amazonaws.com/AWSServiceRoleForRedshift",
          "Condition": {
            "StringLike": {
              "iam:AWSServiceName": "redshift-data.amazonaws.com"
            }
          }
        }
      ]
    },
    "VersionId": "v5",
    "IsDefaultVersion": true,
    "CreateDate": "2023-04-07T18:18:32+00:00"
  }
}