Skip to main content

permissions

Creates, updates, deletes, gets or lists a permissions resource.

Overview

Namepermissions
TypeResource
Idaws.lakeformation.permissions

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
next_tokenstringA continuation token, if this is not the first call to retrieve this list.
principal_resource_permissionsarrayA list of principals and their permissions on the resource for the specified principal and resource types.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_permissionsselectregionReturns a list of the principal permissions on the resource, filtered by the permissions of the caller. For example, if you are granted an ALTER permission, you are able to see only the principal permissions for ALTER. This operation returns only those permissions that have been explicitly granted. If both Principal and Resource parameters are provided, the response returns effective permissions rather than the explicitly granted permissions. For information about permissions, see Security and Access Control to Metadata and Data.
revoke_permissionsupdateregion, Principal, Resource, PermissionsRevokes permissions to the principal to access metadata in the Data Catalog and data organized in underlying data storage such as Amazon S3.
batch_grant_permissionsexecregion, EntriesBatch operation to grant permissions to the principal.
batch_revoke_permissionsexecregion, EntriesBatch operation to revoke permissions from the principal.
grant_permissionsexecregion, Principal, Resource, PermissionsGrants permissions to the principal to access metadata in the Data Catalog and data organized in underlying data storage such as Amazon S3. For information about permissions, see Security and Access Control to Metadata and Data.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
regionstringAWS region (default: us-east-1)

SELECT examples

Returns a list of the principal permissions on the resource, filtered by the permissions of the caller. For example, if you are granted an ALTER permission, you are able to see only the principal permissions for ALTER. This operation returns only those permissions that have been explicitly granted. If both Principal and Resource parameters are provided, the response returns effective permissions rather than the explicitly granted permissions. For information about permissions, see Security and Access Control to Metadata and Data.

SELECT
next_token,
principal_resource_permissions
FROM aws.lakeformation.permissions
WHERE region = '{{ region }}' -- required
;

UPDATE examples

Revokes permissions to the principal to access metadata in the Data Catalog and data organized in underlying data storage such as Amazon S3.

UPDATE aws.lakeformation.permissions
SET
CatalogId = '{{ CatalogId }}',
Principal = '{{ Principal }}',
Resource = '{{ Resource }}',
Permissions = '{{ Permissions }}',
Condition = '{{ Condition }}',
PermissionsWithGrantOption = '{{ PermissionsWithGrantOption }}'
WHERE
region = '{{ region }}' --required
AND Principal = '{{ Principal }}' --required
AND Resource = '{{ Resource }}' --required
AND Permissions = '{{ Permissions }}' --required;

Lifecycle Methods

Batch operation to grant permissions to the principal.

EXEC aws.lakeformation.permissions.batch_grant_permissions
@region='{{ region }}' --required
@@json=
'{
"CatalogId": "{{ CatalogId }}",
"Entries": "{{ Entries }}"
}'
;