GRANT permission does not work on column level access control for table in unity catalog
Options
- 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:
- Labels:
-
SQL Command
-
Unity Catalog