cancel
Showing results for 
Search instead for 
Did you mean: 
Community Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

Permissions on Unity Catalog Table Constraints

RobsonNLPT
New Contributor III

Hi all.

I've used new options to add constraints to UC tables

Even granting permissions to an user (ALL PRIVILEGES) on particular schema we have errors when trying to add PKs. The message doesn't make sense (PERMISSION_DENIED: User is not an owner of Table).The only option to solve this issue is granting ownership on tables he is working.I was expecting ALL PRIVILEGES to cover all DDL operations. Is this an issue on this public preview?

Best

Robson

 

 

 

1 REPLY 1

saikumar246
New Contributor III
New Contributor III

Hi, @RobsonNLPT Thank you for bringing your concern here.

I understand that you are granting (ALL PRIVILEGES) on a particular schema to the user and while that user is trying to add the Primary Key, getting (PERMISSION_DENIED: User is not an owner of Table). It is expected, because in Databricks altering the table, deleting the table or adding the PKs(any alter operations on the table) should need owner privilege on the table. Please see the below link for your reference regarding adding PKs.

https://docs.databricks.com/en/machine-learning/feature-store/uc/feature-tables-uc.html#:~:text=Only...

In Databricks, granting ALL PRIVILEGES on the object means you are granting the below permissions that do not include all the DDL operations.

saikumar246_0-1707745880381.png

You can follow this link to understand more about the General Unity Catalog privilege types in the Databricks:- https://docs.databricks.com/en/data-governance/unity-catalog/manage-privileges/privileges.html#gener...

Please leave a like if this answers your question, follow-ups are appreciated.

Regards,

Sai Kumar

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.