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:
![NarenderKumar_2-1715253228379.png NarenderKumar_2-1715253228379.png](/t5/image/serverpage/image-id/7507i870C01F7F57E0B5E/image-size/medium/is-moderation-mode/true?v=v2&px=400)
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.
![NarenderKumar_1-1715253206943.png NarenderKumar_1-1715253206943.png](/t5/image/serverpage/image-id/7506i5283892DA19CC614/image-size/medium/is-moderation-mode/true?v=v2&px=400)
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:
![NarenderKumar_3-1715253369442.png NarenderKumar_3-1715253369442.png](/t5/image/serverpage/image-id/7508i105A37EEC8544E9F/image-size/medium/is-moderation-mode/true?v=v2&px=400)
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.