I am trying to provide access in unity catalog using the SQL commands.
I am following the below documentation:
https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/manage-privileges/
It suggests to create SQL commands in below format:
GRANT <privilege-type> ON <securable-type> <securable-name> TO <principal>
I have prepared following 3 commnads using above standard but all of them are failing.
Command -> GRANT USE CATALOG ON CATALOG uda_dev TO <my user group>
Error -> [PARSE_SYNTAX_ERROR] Syntax error at or near 'USE'. SQLSTATE: 42601
Command -> GRANT USE SCHEMA ON CATALOG uda_dev TO <my user group>
Error -> [PARSE_SYNTAX_ERROR] Syntax error at or near 'USE'. SQLSTATE: 42601
Command -> GRANT SELECT ON CATALOG uda_dev TO <my user group>
Error -> [PARSE_SYNTAX_ERROR] Syntax error at or near 'CATALOG': missing 'SHARE'. SQLSTATE: 42601
I believe my syntax is correct only. because the USE CATALOG, USE SCHEMA and SELECT are valid privilege type on a catalog as shown below:
I tried running these commands from SQL editor and notebook both.
I am getting the same issue.
My main goal is to provide table read access for all the tables in a particular schema to a user group.
I request to please help how to prepare the SQL commands.