AmazonRedshiftFederatedAuthorization

Summary

This is an ease-of-use policy for running queries with Amazon Redshift Federated Authorization

Permissions imported from the AWS Managed Policy Reference Guide; other sections pending editorial review.

Identity

ARN

arn:aws:iam::aws:policy/AmazonRedshiftFederatedAuthorizationCopy ARN

Default version

v3

Created

2025-11-22

Last edited

2026-02-12

Services

glue, sts

Control-plane actions (17)

By access level: 7 Read, 10 Write.

Data-plane actions (0)

By access level: none.

This policy grants no actions in this plane.

Excluded and conditional actions

No patterns are excluded by NotAction or Deny statements.

Resource scope and attachment

Resource scope across granted actions: scoped.

Can be attached: Yes, to users, groups and roles.

Why this tier

• Grants 10 write, tagging or permissions-management actions, short of full control of any service.

Guidance

Pending editorial review. The permission data on this page comes straight from AWS; this section will be filled in once a reviewed guide exists.

Related policies

Same service

• AmazonAthenaFullAccess
• AmazonDataZoneEnvironmentRolePermissionsBoundary
• AmazonDataZoneGlueManageAccessRolePolicy
• AmazonDataZonePreviewConsoleFullAccess
• AmazonDataZoneProjectRolePermissionsBoundary
• AmazonDataZoneSageMakerEnvironmentRolePermissionsBoundary
• AmazonDataZoneSageMakerProvisioningRolePolicy
• AmazonGrafanaAthenaAccess

Same domain

• AmazonChimeSDKMediaPipelinesServiceLinkedRolePolicy
• AmazonChimeSDKMessagingServiceRolePolicy
• AmazonDataZoneDomainExecutionRolePolicy
• AmazonDataZoneFullAccess
• AmazonDataZoneFullUserAccess
• AmazonDataZoneRedshiftGlueProvisioningPolicy
• AmazonDataZoneRedshiftManageAccessRolePolicy
• AmazonElasticMapReduceforAutoScalingRole

Frequently asked questions

Pending editorial review. The permission data on this page comes straight from AWS; this section will be filled in once a reviewed guide exists.

Policy JSON

Download policy.json

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "AmazonRedshiftFederatedAuthorization",
      "Effect": "Allow",
      "Action": [
        "glue:GetCatalog",
        "glue:GetCatalogs",
        "glue:GetDatabase",
        "glue:GetDatabases",
        "glue:GetTable",
        "glue:GetTables",
        "glue:GetUserDefinedFunctions",
        "glue:CreateDatabase",
        "glue:CreateTable",
        "glue:DeleteDatabase",
        "glue:DeleteTable",
        "glue:UpdateCatalog",
        "glue:UpdateDatabase",
        "glue:UpdateTable",
        "glue:RenameTable",
        "glue:FederateAuthorization"
      ],
      "Resource": [
        "arn:aws:glue:*:*:*"
      ],
      "Condition": {
        "StringEquals": {
          "glue:FederatedAuthorizationSource": "Redshift"
        }
      }
    },
    {
      "Sid": "AmazonRedshiftIdentityCenterSetContext",
      "Effect": "Allow",
      "Action": [
        "sts:SetContext"
      ],
      "Resource": "arn:aws:sts::*:self"
    }
  ]
}

Version history

Current version v3, edited by AWS on 2026-02-12. Version history is recorded from 2026-11-11. Earlier versions are in the IAM console under Policy versions.

Attach snippets

aws iam attach-role-policy --role-name ROLE_NAME --policy-arn arn:aws:iam::aws:policy/AmazonRedshiftFederatedAuthorization
aws iam attach-user-policy --user-name USER_NAME --policy-arn arn:aws:iam::aws:policy/AmazonRedshiftFederatedAuthorization
aws iam attach-group-policy --group-name GROUP_NAME --policy-arn arn:aws:iam::aws:policy/AmazonRedshiftFederatedAuthorization

Resources:
  ExampleRole:
    Type: AWS::IAM::Role
    Properties:
      AssumeRolePolicyDocument: {}  # replace with your trust policy
      ManagedPolicyArns:
        - arn:aws:iam::aws:policy/AmazonRedshiftFederatedAuthorization

resource "aws_iam_role_policy_attachment" "amazonredshiftfederatedauthorization" {
  role       = aws_iam_role.example.name
  policy_arn = "arn:aws:iam::aws:policy/AmazonRedshiftFederatedAuthorization"
}

role.addManagedPolicy(
  iam.ManagedPolicy.fromAwsManagedPolicyName("AmazonRedshiftFederatedAuthorization"),
);

Sources

Pending editorial review. No editorial sources are listed yet.

• Official AWS reference for AmazonRedshiftFederatedAuthorization
• Report a data issue