ObjectACLs

Returns information for ACLs of a specific object.

Table Specific Information

Select

The add-in will use the Google Cloud Storage API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in.

Object supports the '=,LIKE' comparisons.
Bucket supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM ObjectACLs WHERE Object = 'TestObject'

SELECT * FROM ObjectACLs WHERE Bucket = 'TestBucket'

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

Columns


Name	Type	Description
Id [KEY]	String	The ID of the access-control entry.
Entity	String	The entity holding the permission.
Role	String	The access permission for the entity.
Email	String	The email address associated with the entity, if any.
EntityId	String	The ID for the entity, if any.
Domain	String	The domain associated with the entity, if any.
ProjectTeamNumber	String	The project number.
ProjectTeamType	String	The team type.
ETag	String	HTTP 1.1 Entity tag for the access-control entry.
Bucket	String	The name of the bucket.
Object	String	The name of the object.

Excel Add-In for Google Cloud Storage

ObjectACLs

Table Specific Information

Select

Columns