topic Re: Show all privileges granted to principal in Administration & Architecture

Show all privileges granted to principal

alm — Mon, 25 Mar 2024 10:19:46 GMT

Given the name of a principal in Databricks (I'm using account-level groups) is there an easy way to query or in other way obtain all privileges granted to this principal?

I know I can obtain the information by querying in several of the system.information_schema and will do that if there isn't a simpler option. It just seems like information that should be readily accessible?

Re: Show all privileges granted to principal

alm — Tue, 09 Apr 2024 05:13:58 GMT

This dosn't really address my problem.

I worked around it and found another solution. It just surprised me that this information isn't readily available

Re: Show all privileges granted to principal

Ivan_Donev — Sun, 14 Apr 2024 19:31:20 GMT

How did you solve your problem? By going through the information_schema or system tables? Or something else?

Re: Show all privileges granted to principal

alm — Mon, 15 Apr 2024 05:50:19 GMT

Yes, I used a combination of the information_schema.{object_type}_privileges tables. As the naming varies, i.e. catalog_name in schema_privileges but table_catalog in table_privileges, it's a bit cumbersome but definitely possible.

Re: Show all privileges granted to principal

sakthi_sujitha — Wed, 10 Jul 2024 00:21:28 GMT

This link will provide details on how to verify all the privileges granted to Service Principals