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

[chanda02]

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 -

[Debayan]

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]

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?