topic Re: GRANT permission does not work on column level access control for table in unity catalog in Data Engineering

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

chanda02 — Fri, 03 Feb 2023 05:43:50 GMT

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 -

chanda02 — Thu, 09 Feb 2023 05:45:36 GMT

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?

Debayan — Mon, 06 Feb 2023 05:58:08 GMT

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.

Please let us know if this helps.