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

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group