topic Re: Databricks SQL permission problems in Data Engineering

Databricks SQL permission problems

g96g — Mon, 19 Dec 2022 08:34:32 GMT

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?

Re: Databricks SQL permission problems

karthik_p — Mon, 19 Dec 2022 16:08:47 GMT

@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

Re: Databricks SQL permission problems

Debayan — Mon, 19 Dec 2022 16:42:54 GMT

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