Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
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?
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.