cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Access control on view

NehaR
New Contributor III

 

We've created a view containing PII mapping values in Unity Catalog. We need to grant other users the ability to query this view and access the mapping values, but we must prevent them from seeing the view's definition. Is it possible to grant "execute" access (querying the view) while completely hiding the view definition in Unity Catalog? The goal is to restrict users from understanding how these mapping values are derived.

1 REPLY 1

kamal_ch
Databricks Employee
Databricks Employee

In Unity Catalog, enabling users to query a view while hiding its definition is currently not supported directly. Unity Catalog requires view definitions to be visible during query execution for metadata access purposes. While querying, users typically need permissions such as SELECT on the view, alongside USAGE on the schema and catalog containing the view.

Dynamic row-level or column-level security can be applied using specific functions or masking in Unity Catalog to restrict access to sensitive data. However, options to fully obscure view definitions or apply "execute-only" access are not explicitly provided within the current capabilities of Unity Catalog.

If your organization requires strict access control that prevents users from seeing view definitions, creating a sandboxed schema or using external tools for governance (such as Privacera or Immuta) might be viable alternatives. These tools can integrate with Unity Catalog to enforce granular privacy policies at the query level

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now