object_permissions

Operations on a object_permissions resource.

Overview

Name	object_permissions
Type	Resource
Id	databricks_workspace.workspace.object_permissions

Fields

Name	Datatype
access_control_list	array
object_id	string
object_type	string

Methods

Name	Accessible by	Required Params	Description
getpermissions	SELECT	workspace_object_id, workspace_object_type, deployment_name	Gets the permissions of a workspace object. Workspace objects can inherit permissions from their parent objects or root object.
updatepermissions	UPDATE	workspace_object_id, workspace_object_type, deployment_name	Updates the permissions on a workspace object. Workspace objects can inherit permissions from their parent objects or root object.
setpermissions	REPLACE	workspace_object_id, workspace_object_type, deployment_name	Sets permissions on an object, replacing existing permissions if they exist. Deletes all direct permissions if none are specified. Objects can inherit permissions from their parent objects or root object.

SELECT examples

SELECT
access_control_list,
object_id,
object_type
FROM databricks_workspace.workspace.object_permissions
WHERE workspace_object_id = '{{ workspace_object_id }}' AND
workspace_object_type = '{{ workspace_object_type }}' AND
deployment_name = '{{ deployment_name }}';

UPDATE example

Updates a object_permissions resource.

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

REPLACE example

Replaces a object_permissions resource.

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