Show all privileges granted to principal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-25-2024 03:19 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-08-2024 10:13 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-14-2024 12:31 PM
How did you solve your problem? By going through the information_schema or system tables? Or something else?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-14-2024 10:49 PM - edited 04-14-2024 10:50 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2024 05:21 PM
This link will provide details on how to verify all the privileges granted to Service Principals
