Question

A data governance officer needs to programmatically audit which principals currently hold the SELECT privilege on tables within the 'finance' catalog. They want to run a SQL query rather than clicking through the Catalog Explorer UI for each object. Which approach lets them retrieve this grant information using standard SQL?

Accepted Answer

Query the views under finance.information_schema (such as table_privileges) to list granted privileges

Answer

Run DESCRIBE HISTORY on each table to view the list of grants applied over time

Answer

Query the hive_metastore.default.grants system table exported by the workspace

Answer

Use SHOW TABLES IN finance to display each table along with its assigned privileges