GRANT permission does not work on column level access control for table in unity catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-02-2023 09:43 PM
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 -
- Labels:
-
ColumnACL
-
SQL Command
-
Unity Catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-05-2023 09:58 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2023 09:45 PM
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?

