Databricks SQL permission problems
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2022 12:34 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2022 08:08 AM
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2022 08:42 AM
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
