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: 

GRANT permission does not work on column level access control for table in unity catalog

chanda02
New Contributor II

I am trying to run below SQL command for granting column specific control to user but it throws error.

I have given USE_CATALOG for catalog and USE_SCHEMA permission for schema for the user and have set current catalog and schema.

I am using Databricks runtime(12.1 (includes Apache Spark 3.3.1, Scala 2.12)) 

cluster and have table access control enabled workspace.

Anyone help on this is highly appreciated.

Command -

%sql

GRANT SELECT (uid, name) ON my_table TO `email`;

Error -

image

2 REPLIES 2

Debayan
Esteemed Contributor III

Hi, you can find the best practises here: https://docs.databricks.com/data-governance/unity-catalog/best-practices.html

Also, for cluster access modes for unity catalog : https://docs.databricks.com/data-governance/unity-catalog/index.html#cluster-security-mode , please make sure supported compute, region and data file format was checked.

Limitations are https://docs.databricks.com/data-governance/unity-catalog/index.html#limitations-1.

Please let us know if this helps.

chanda02
New Contributor II

Hi, I have gone through these links. Granular permissions for specific columns is given by creating dynamic views. https://docs.databricks.com/data-governance/unity-catalog/create-views.html#column-level-permissions

In my case i am able to create view, but can you please clarify if grant select permission for specific columns for a table is possible?

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group