Returns the access control list (ACL) grant entries for an object, defining read and write permissions at the object level.

View-Specific Information

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

SELECT

The following queries are processed server-side:

SELECT * FROM ObjectACLs WHERE Bucket = 'TestBucket'

SELECT * FROM ObjectACLs WHERE Object = 'TestObject' AND Bucket = 'TestBucket'

Columns

Name	Type	Description
GranteeType	String	Grantee type (CanonicalUser, Group, AmazonCustomerByEmail).
GranteeId	String	Canonical user ID of the grantee.
GranteeDisplayName	String	Display name of the grantee.
GranteeURI	String	URI identifying the grantee group.
Permission	String	The granted permission (FULL_CONTROL, READ, WRITE, READ_ACP, WRITE_ACP).
Bucket	String	The name of the S3 bucket that contains the object associated with this ACL.