Skip to main content

token_permissions

Operations on a token_permissions resource.

Overview

Nametoken_permissions
TypeResource
Iddatabricks_workspace.workspace.token_permissions

Fields

NameDatatype
access_control_listarray
object_idstring
object_typestring

Methods

NameAccessible byRequired ParamsDescription
getpermissionsSELECTdeployment_nameGets the permissions of all tokens. Tokens can inherit permissions from their root object.
updatepermissionsUPDATEdeployment_nameUpdates the permissions on all tokens. Tokens can inherit permissions from their root object.
setpermissionsREPLACEdeployment_nameSets permissions on an object, replacing existing permissions if they exist. Deletes all direct permissions if none are specified. Objects can inherit permissions from their root object.

SELECT examples

SELECT
access_control_list,
object_id,
object_type
FROM databricks_workspace.workspace.token_permissions
WHERE deployment_name = '{{ deployment_name }}';

UPDATE example

Updates a token_permissions resource.

/*+ update */
-- replace field1, field2, etc. with the fields you want to update
UPDATE databricks_workspace.workspace.token_permissions
SET field1 = '{{ value1 }}',
field2 = '{{ value2 }}', ...
WHERE deployment_name = '{{ deployment_name }}';

REPLACE example

Replaces a token_permissions resource.

/*+ update */
-- replace field1, field2, etc. with the fields you want to update
REPLACE databricks_workspace.workspace.token_permissions
SET field1 = '{ value1 }',
field2 = '{ value2 }', ...
WHERE deployment_name = '{{ deployment_name }}';