effective_grants
Creates, updates, deletes, gets or lists an effective_grants resource.
Overview
| Name | effective_grants |
| Type | Resource |
| Id | databricks_workspace.unitycatalog.effective_grants |
Fields
The following fields are returned by SELECT queries:
- geteffective
The effective 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 |
|---|---|---|---|---|
geteffective | select | deployment_name | Gets the effective 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
- geteffective
Gets the effective permissions for a securable.
SELECT
principal,
privileges
FROM databricks_workspace.unitycatalog.effective_grants
WHERE deployment_name = '{{ deployment_name }}' -- required;