Walter_C
Databricks Employee
Databricks Employee

In Databricks the object permissions are based in the object itself and not the user. Unfortunately as of now there is no way to get all the objects permissions in a single built in query.

There is custom options as for example for clusters, first run the API to list clusters and save all the cluster id in a list. Once you have this list of cluster ids, you can iterate by each cluster using the get permissions for clusters API call.

Right now I dont have any custom code available on my side that will make this same process but it is an idea on how you can do it, it will apply the same for jobs.

In regards tables if you are using Unity Catalog you can refer to API: https://docs.databricks.com/api/workspace/grants/get 

View solution in original post