cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
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
Databricks Employee
Databricks Employee

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

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now