AmazonRedshiftFullAccess

Last Modified

Mar 12, 2026

March 12, 2026 at 09:28 PM UTC

Version

Total Versions

Created

Jul 7, 2022

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
Can rewrite resource policies and sharing
Grants 5 permissions management actions across 1 service (redshift) on any resource, enough to share resources outside the account.
redshift:createsnapshotcopygrantredshift:deleteresourcepolicyredshift:putresourcepolicyredshift:revokeendpointaccessredshift:revokesnapshotaccess
Use with caution: Turn on IAM Access Analyzer external access findings, and keep account-level guards like S3 Block Public Access enabled.
Medium
Full access to 2 services on every resource
Uses redshift:*, redshift-serverless:* with Resource "*" and no condition, so every action AWS adds to those services later is granted too.
redshift:*redshift-serverless:*
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.

IAM Access Analyzer (1)

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

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
88
89
90{
  "PolicyVersion": {
    "Document": {
      "Version": "2012-10-17",
      "Statement": [
        {
          "Action": [
            "redshift:*",
            "redshift-serverless:*",
            "ec2:DescribeAccountAttributes",
            "ec2:DescribeAddresses",
            "ec2:DescribeAvailabilityZones",
            "ec2:DescribeSecurityGroups",
            "ec2:DescribeSubnets",
            "ec2:DescribeVpcs",
            "ec2:DescribeInternetGateways",
            "sns:CreateTopic",
            "sns:Get*",
            "sns:List*",
            "cloudwatch:Describe*",
            "cloudwatch:Get*",
            "cloudwatch:List*",
            "cloudwatch:PutMetricAlarm",
            "cloudwatch:EnableAlarmActions",
            "cloudwatch:DisableAlarmActions",
            "tag:GetResources",
            "tag:UntagResources",
            "tag:GetTagValues",
            "tag:GetTagKeys",
            "tag:TagResources"
          ],
          "Effect": "Allow",
          "Resource": "*"
        },
        {
          "Effect": "Allow",
          "Action": "iam:CreateServiceLinkedRole",
          "Resource": "arn:aws:iam::*:role/aws-service-role/redshift.amazonaws.com/AWSServiceRoleForRedshift",
          "Condition": {
            "StringLike": {
              "iam:AWSServiceName": "redshift.amazonaws.com"
            }
          }
        },
        {
          "Sid": "DataAPIPermissions",
          "Action": [
            "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"
          ],
          "Effect": "Allow",
          "Resource": "*"
        },
        {
          "Sid": "SecretsManagerListPermissions",
          "Action": [
            "secretsmanager:ListSecrets"
          ],
          "Effect": "Allow",
          "Resource": "*"
        },
        {
          "Sid": "SecretsManagerCreateGetPermissions",
          "Action": [
            "secretsmanager:CreateSecret",
            "secretsmanager:GetSecretValue",
            "secretsmanager:TagResource"
          ],
          "Effect": "Allow",
          "Resource": "*",
          "Condition": {
            "StringLike": {
              "secretsmanager:ResourceTag/RedshiftDataFullAccess": "*"
            }
          }
        }
      ]
    },
    "VersionId": "v5",
    "IsDefaultVersion": true,
    "CreateDate": "2022-07-07T23:31:13+00:00"
  }
}