ObjectsACL

Displays the ACL for a specific object, defining read and write permissions at the object level.

Table Specific Information

Select

The component uses the Amazon S3 API to process search criteria that refers to the Object and Bucket columns. The component processes other filters client side within the component. For example, the following queries are processed server side.

SELECT * FROM ObjectsACL WHERE Object = 'TestObject'

SELECT * FROM ObjectsACL WHERE Bucket = 'TestBucket'

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

Columns


Name	Type	Description
GranteeType	String	Indicates the type of grantee receiving permissions, such as an individual AWS user, an AWS account, or a 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, typically associated with the AWS account.
GranteeURI	String	The URI identifying a predefined Amazon S3 group granted access, such as AllUsers or AuthenticatedUsers.
Permission	String	Specifies the access level assigned to the grantee, such as READ, WRITE, or FULL_CONTROL.
Bucket	String	The name of the S3 bucket that contains the object associated with this ACL.
Object	String	The key (name) of the S3 object to which this ACL applies.

SSIS Components for Amazon S3

ObjectsACL

Table Specific Information

Select

Columns