AmazonRedshiftDataFullAccess
Description: This policy provides full access to Amazon Redshift Data APIs. This policy also grants scoped access to other required services.
AmazonRedshiftDataFullAccess
is an AWS managed policy.
Using this policy
You can attach AmazonRedshiftDataFullAccess
to your users, groups, and roles.
Policy details
-
Type: AWS managed policy
-
Creation time: September 09, 2020, 19:23 UTC
-
Edited time: April 07, 2023, 18:18 UTC
-
ARN:
arn:aws:iam::aws:policy/AmazonRedshiftDataFullAccess
Policy version
Policy version: v5 (default)
The policy's default version is the version that defines the permissions for the policy. When a user or role with the policy makes a request to access an AWS resource, AWS checks the default version of the policy to determine whether to allow the request.
JSON policy 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" } } } ] }