grants
Creates, updates, deletes, gets or lists a grants resource.
Overview
| Name | grants |
| Type | Resource |
| Id | databricks_workspace.unitycatalog.grants |
Fields
The following fields are returned by SELECT queries:
- get
The permissions list for securable was successfully retrieved.
| Name | Datatype | Description |
|---|---|---|
principal | string | |
privileges | array |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | deployment_name | Gets the permissions for a securable. | |
update | update | deployment_name | Updates the permissions for a securable. |
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 the permissions for a securable.
SELECT
principal,
privileges
FROM databricks_workspace.unitycatalog.grants
WHERE deployment_name = '{{ deployment_name }}' -- required;
UPDATE examples
- update
Updates the permissions for a securable.
UPDATE databricks_workspace.unitycatalog.grants
SET
data__changes = '{{ changes }}'
WHERE
deployment_name = '{{ deployment_name }}' --required
RETURNING
privilege_assignments;