Displays the access control list (ACL) for a bucket, showing user- and group-level permissions that define who can read, write, or manage bucket contents.

View-Specific Information

The connector uses the Amazon S3 API to process filter criteria that reference the Bucket column, and processes all other filters client-side within the connector. This view returns the ACL of a single bucket, so each query must include a Bucket filter.

SELECT

The following query is processed server-side:

SELECT * FROM BucketACLs WHERE Bucket = 'TestBucket'

Columns

Name	Type	Description
GranteeType	String	Indicates the type of grantee receiving permissions, such as a specific user, group, or predefined Amazon S3 group.
GranteeId	String	The unique identifier of the AWS account or user to whom permissions are granted.
GranteeDisplayName	String	The human-readable display name of the grantee, often the AWS account's display name.
GranteeURI	String	The URI that identifies a predefined Amazon S3 group receiving permissions (such as AllUsers or AuthenticatedUsers).
Permission	String	Specifies the level of access granted to the grantee, such as READ, WRITE, or FULL_CONTROL.
Bucket	String	The name of the S3 bucket to which this access control list (ACL) entry applies.