A Databricks data analyst wants to confirm which privileges have been granted on a specific table in Unity Catalog. Which command should they run?

Question

Accepted Answer

B. SHOW GRANTS ON TABLE main.sales.orders. The `SHOW GRANTS ON TABLE` command returns all privileges that have been granted on a specific table, including who granted them and to whom. DESCRIBE HISTORY shows the Delta transaction log history, not security grants. The information_schema.table_privileges view is an alternative but requires knowing the catalog context; SHOW GRANTS is the direct and standard approach. DESCRIBE TABLE EXTENDED shows table metadata but not security grants.

A Databricks data analyst wants to confirm which privileges have been granted on a specific table in Unity Catalog. Which command should they run?

Related Questions

Discussion