effective_grants

Operations on a effective_grants resource.

Overview

Name	effective_grants
Type	Resource
Id	databricks_workspace.unitycatalog.effective_grants

Fields

Name	Datatype
principal	string
privileges	array

Methods

Name	Accessible by	Required Params	Description
geteffective	SELECT	full_name, securable_type, deployment_name	Gets the effective permissions for a securable.

SELECT examples

SELECT
principal,
privileges
FROM databricks_workspace.unitycatalog.effective_grants
WHERE full_name = '{{ full_name }}' AND
securable_type = '{{ securable_type }}' AND
deployment_name = '{{ deployment_name }}';