AWSCleanRoomsFullAccessNoQuerying

Summary

Allows full access to AWS Clean Rooms resources except for querying in a collaboration and access to related AWS services. The AWS Clean Rooms User Guide says it grants administrative permissions for full access (read, write and update) to resources and metadata in a collaboration, and excludes access to perform queries.

Permissions imported from the AWS Managed Policy Reference Guide; other sections reviewed against the listed AWS sources.

Identity

ARN

arn:aws:iam::aws:policy/AWSCleanRoomsFullAccessNoQueryingCopy ARN

Default version

v7

Created

2023-01-12

Last edited

2026-02-12

Services

cleanrooms, glue, iam, logs

Control-plane actions (74)

By access level: 17 List, 1 Permissions management, 28 Read, 2 Tagging, 26 Write.

Data-plane actions (0)

By access level: none.

This policy grants no actions in this plane.

Excluded and conditional actions

• cleanrooms:StartProtectedQuery (deny, statement 1): 1 matching actions
• cleanrooms:UpdateProtectedQuery (deny, statement 1): 1 matching actions

Resource scope and attachment

Resource scope across granted actions: mixed.

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

Why this tier

• Grants 29 write, tagging or permissions-management actions, short of full control of any service.
• Grants iam:PassRole, but only for scoped roles or under conditions (for example iam:PassedToService).

Guidance

Related policies

Same service

• AccessAnalyzerServiceRolePolicy
• AccountManagementFromVercel
• AlexaForBusinessGatewayExecution
• AmazonAPIGatewayPushToCloudWatchLogs
• AmazonApplicationRecoveryControllerRegionSwitchPlanExecutionPolicy
• AmazonAthenaFullAccess
• AmazonBraketFullAccess
• AmazonBraketJobsExecutionPolicy

Same domain

• AmazonChimeSDKMediaPipelinesServiceLinkedRolePolicy
• AmazonChimeSDKMessagingServiceRolePolicy
• AmazonDataZoneDomainExecutionRolePolicy
• AmazonDataZoneEnvironmentRolePermissionsBoundary
• AmazonDataZoneFullAccess
• AmazonDataZoneFullUserAccess
• AmazonDataZoneGlueManageAccessRolePolicy
• AmazonDataZoneProjectRolePermissionsBoundary

Frequently asked questions

When should I attach AWSCleanRoomsFullAccessNoQuerying?

The AWS Clean Rooms User Guide says you can attach AWSCleanRoomsFullAccessNoQuerying to your IAM principals, and that it grants administrative permissions for full access to resources and metadata in a collaboration while excluding queries. Attach it for administrators who manage collaborations but should not run queries.

What does AWSCleanRoomsFullAccessNoQuerying grant?

It allows 46 cleanrooms actions on all resources, passing service roles named with cleanrooms to AWS Clean Rooms, reading AWS Glue metadata and managing CloudWatch Logs delivery. It explicitly denies cleanrooms:StartProtectedQuery and cleanrooms:UpdateProtectedQuery.

What are the security risks of AWSCleanRoomsFullAccessNoQuerying?

It can create, update and delete collaborations, configured tables and memberships, and pass service roles. The deny covers only two protected query actions; viewing protected queries is still allowed. AWS managed policies don't grant least privilege permissions, and you must consider the security risk of granting principals more permissions than they need. AWS updates to the policy affect every identity it is attached to.

Policy JSON

Download policy.json

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "CleanRoomsAccess",
      "Effect": "Allow",
      "Action": [
        "cleanrooms:BatchGetCollaborationAnalysisTemplate",
        "cleanrooms:BatchGetSchema",
        "cleanrooms:BatchGetSchemaAnalysisRule",
        "cleanrooms:CreateAnalysisTemplate",
        "cleanrooms:CreateCollaboration",
        "cleanrooms:CreateConfiguredTable",
        "cleanrooms:CreateConfiguredTableAnalysisRule",
        "cleanrooms:CreateConfiguredTableAssociation",
        "cleanrooms:CreateMembership",
        "cleanrooms:DeleteAnalysisTemplate",
        "cleanrooms:DeleteCollaboration",
        "cleanrooms:DeleteConfiguredTable",
        "cleanrooms:DeleteConfiguredTableAnalysisRule",
        "cleanrooms:DeleteConfiguredTableAssociation",
        "cleanrooms:DeleteMember",
        "cleanrooms:DeleteMembership",
        "cleanrooms:GetAnalysisTemplate",
        "cleanrooms:GetCollaborationAnalysisTemplate",
        "cleanrooms:GetCollaboration",
        "cleanrooms:GetConfiguredTable",
        "cleanrooms:GetConfiguredTableAnalysisRule",
        "cleanrooms:GetConfiguredTableAssociation",
        "cleanrooms:GetMembership",
        "cleanrooms:GetProtectedQuery",
        "cleanrooms:GetSchema",
        "cleanrooms:GetSchemaAnalysisRule",
        "cleanrooms:ListAnalysisTemplates",
        "cleanrooms:ListCollaborationAnalysisTemplates",
        "cleanrooms:ListCollaborations",
        "cleanrooms:ListConfiguredTableAssociations",
        "cleanrooms:ListConfiguredTables",
        "cleanrooms:ListMembers",
        "cleanrooms:ListMemberships",
        "cleanrooms:ListProtectedQueries",
        "cleanrooms:ListSchemas",
        "cleanrooms:UpdateAnalysisTemplate",
        "cleanrooms:UpdateCollaboration",
        "cleanrooms:UpdateConfiguredTable",
        "cleanrooms:UpdateConfiguredTableReference",
        "cleanrooms:UpdateConfiguredTableAllowedColumns",
        "cleanrooms:UpdateConfiguredTableAnalysisRule",
        "cleanrooms:UpdateConfiguredTableAssociation",
        "cleanrooms:UpdateMembership",
        "cleanrooms:ListTagsForResource",
        "cleanrooms:UntagResource",
        "cleanrooms:TagResource"
      ],
      "Resource": "*"
    },
    {
      "Sid": "CleanRoomsNoQuerying",
      "Effect": "Deny",
      "Action": [
        "cleanrooms:StartProtectedQuery",
        "cleanrooms:UpdateProtectedQuery"
      ],
      "Resource": "*"
    },
    {
      "Sid": "PassServiceRole",
      "Effect": "Allow",
      "Action": [
        "iam:PassRole"
      ],
      "Resource": "arn:aws:iam::*:role/service-role/*cleanrooms*",
      "Condition": {
        "StringEquals": {
          "iam:PassedToService": "cleanrooms.amazonaws.com"
        }
      }
    },
    {
      "Sid": "ListRolesToPickServiceRole",
      "Effect": "Allow",
      "Action": [
        "iam:ListRoles"
      ],
      "Resource": "*"
    },
    {
      "Sid": "GetRoleAndListRolePoliciesToInspectServiceRole",
      "Effect": "Allow",
      "Action": [
        "iam:GetRole",
        "iam:ListRolePolicies",
        "iam:ListAttachedRolePolicies"
      ],
      "Resource": "arn:aws:iam::*:role/service-role/*cleanrooms*"
    },
    {
      "Sid": "ListPoliciesToInspectServiceRolePolicy",
      "Effect": "Allow",
      "Action": [
        "iam:ListPolicies"
      ],
      "Resource": "*"
    },
    {
      "Sid": "GetPolicyToInspectServiceRolePolicy",
      "Effect": "Allow",
      "Action": [
        "iam:GetPolicy",
        "iam:GetPolicyVersion"
      ],
      "Resource": "arn:aws:iam::*:policy/*cleanrooms*"
    },
    {
      "Sid": "ConsoleDisplayTables",
      "Effect": "Allow",
      "Action": [
        "glue:GetDatabase",
        "glue:GetDatabases",
        "glue:GetTable",
        "glue:GetTables",
        "glue:GetPartition",
        "glue:GetPartitions",
        "glue:GetSchema",
        "glue:GetSchemaVersion",
        "glue:BatchGetPartition"
      ],
      "Resource": "*"
    },
    {
      "Sid": "EstablishLogDeliveries",
      "Effect": "Allow",
      "Action": [
        "logs:CreateLogDelivery",
        "logs:GetLogDelivery",
        "logs:UpdateLogDelivery",
        "logs:DeleteLogDelivery",
        "logs:ListLogDeliveries"
      ],
      "Resource": "*",
      "Condition": {
        "ForAnyValue:StringEquals": {
          "aws:CalledVia": "cleanrooms.amazonaws.com"
        }
      }
    },
    {
      "Sid": "SetupLogGroupsDescribe",
      "Effect": "Allow",
      "Action": [
        "logs:DescribeLogGroups"
      ],
      "Resource": "*",
      "Condition": {
        "ForAnyValue:StringEquals": {
          "aws:CalledVia": "cleanrooms.amazonaws.com"
        }
      }
    },
    {
      "Sid": "SetupLogGroupsCreate",
      "Effect": "Allow",
      "Action": [
        "logs:CreateLogGroup"
      ],
      "Resource": "arn:aws:logs:*:*:log-group:/aws/cleanrooms*",
      "Condition": {
        "ForAnyValue:StringEquals": {
          "aws:CalledVia": "cleanrooms.amazonaws.com"
        }
      }
    },
    {
      "Sid": "SetupLogGroupsResourcePolicy",
      "Effect": "Allow",
      "Action": [
        "logs:DescribeResourcePolicies",
        "logs:PutResourcePolicy"
      ],
      "Resource": "*",
      "Condition": {
        "ForAnyValue:StringEquals": {
          "aws:CalledVia": "cleanrooms.amazonaws.com"
        }
      }
    },
    {
      "Sid": "ConsoleLogSummaryQueryLogs",
      "Effect": "Allow",
      "Action": [
        "logs:StartQuery"
      ],
      "Resource": "arn:aws:logs:*:*:log-group:/aws/cleanrooms*"
    },
    {
      "Sid": "ConsoleLogSummaryObtainLogs",
      "Effect": "Allow",
      "Action": [
        "logs:GetQueryResults"
      ],
      "Resource": "*"
    }
  ]
}

Version history

Current version v7, 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/AWSCleanRoomsFullAccessNoQuerying
aws iam attach-user-policy --user-name USER_NAME --policy-arn arn:aws:iam::aws:policy/AWSCleanRoomsFullAccessNoQuerying
aws iam attach-group-policy --group-name GROUP_NAME --policy-arn arn:aws:iam::aws:policy/AWSCleanRoomsFullAccessNoQuerying

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

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

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

Sources

• AWSCleanRoomsFullAccessNoQuerying (AWS Managed Policy Reference Guide) (retrieved 2026-11-13; supports summary, practicalScope, useCases, securityConsiderations, assignmentGuidance, faqs)
• AWS managed policies for AWS Clean Rooms (AWS Clean Rooms User Guide) (retrieved 2026-11-13; supports summary, useCases, assignmentGuidance, faqs)
• Grant a user permissions to pass a role to an AWS service (IAM User Guide) (retrieved 2026-11-13; supports securityConsiderations)
• Managed policies and inline policies (IAM User Guide) (retrieved 2026-11-12; supports securityConsiderations, faqs)
• AWS managed policies for job functions (IAM User Guide) (retrieved 2026-11-12; supports bestPractices, faqs)

• Official AWS reference for AWSCleanRoomsFullAccessNoQuerying
• AWS service guide
• Report a data issue