permissions
Creates, updates, deletes, gets or lists a permissions resource.
Overview
| Name | permissions |
| Type | Resource |
| Id | databricks_workspace.dbsql.permissions |
Fields
The following fields are returned by SELECT queries:
- get
| Name | Datatype | Description |
|---|---|---|
object_id | string | |
access_control_list | array | |
object_type | string |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | deployment_name | Gets a JSON representation of the access control list (ACL) for a specified object. | |
set | replace | deployment_name | Sets the access control list (ACL) for a specified object. This operation will complete rewrite the ACL. | |
transferownership | exec | deployment_name | Transfer ownership of a single object. |
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.
| Name | Datatype | Description |
|---|---|---|
deployment_name | string | The Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc) |
SELECT examples
- get
Gets a JSON representation of the access control list (ACL) for a specified object.
SELECT
object_id,
access_control_list,
object_type
FROM databricks_workspace.dbsql.permissions
WHERE deployment_name = '{{ deployment_name }}' -- required;
REPLACE examples
- set
Sets the access control list (ACL) for a specified object. This operation will complete rewrite the ACL.
REPLACE databricks_workspace.dbsql.permissions
SET
data__access_control_list = '{{ access_control_list }}'
WHERE
deployment_name = '{{ deployment_name }}' --required
RETURNING
object_id,
access_control_list,
object_type;
Lifecycle Methods
- transferownership
Transfer ownership of a single object.
EXEC databricks_workspace.dbsql.permissions.transferownership
@deployment_name='{{ deployment_name }}' --required
@@json=
'{
"new_owner": "{{ new_owner }}"
}';