Skip to main content

permissions

Operations on a permissions resource.

Overview

Namepermissions
TypeResource
Iddatabricks_workspace.repos.permissions

Fields

NameDatatype
access_control_listarray
object_idstring
object_typestring

Methods

NameAccessible byRequired ParamsDescription
getpermissionsSELECTrepo_id, deployment_nameGets the permissions of a repo. Repos can inherit permissions from their root object.
updatepermissionsUPDATErepo_id, deployment_nameUpdates the permissions on a repo. Repos can inherit permissions from their root object.
setpermissionsREPLACErepo_id, deployment_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.repos.permissions
WHERE repo_id = '{{ repo_id }}' AND
deployment_name = '{{ deployment_name }}';

UPDATE example

Updates a permissions resource.

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

REPLACE example

Replaces a permissions resource.

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