cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Databricks SQL permission problems

g96g
New Contributor III

We are using a catalog and normally I have the ALL PREVELAGES user status but Im not able to modify the SQL script which is created by some of my colleagues. They have to give me an access and after that Im able to modify. How can I solve this problem as this is not efficient way to work?

2 REPLIES 2

karthik_p
Esteemed Contributor

@Givi Salu​ usually governance is to secure access for other objects that does not below to us. if you have all privileges on schema/table then you should be able to. is there any specific reason that you are trying to access or modify table of others without their concern please. we may get more inputs from our community @pat​ @Hubert Dudek​ can you please comment when you get some time

Debayan
Esteemed Contributor III
Esteemed Contributor III

Hi, when you are not able to modify could you please confirm the error you are receiving?

Also, you can refer to https://docs.databricks.com/_static/notebooks/set-owners-notebook.html and https://docs.databricks.com/sql/admin/transfer-ownership.html

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.