An analyst reports they cannot query main.sales.orders even though the table owner ran GRANT SELECT ON TABLE main.sales.orders to the analyst. The analyst holds no other grants on the catalog or the schema. What is the minimum additional set of privileges required so the analyst can successfully read this table?
Answer & explanation
Correct answer: D
WHY D: To read a table a user needs SELECT on the table plus the traversal privileges USE CATALOG on its catalog and USE SCHEMA on its schema; without traversal the SELECT is unusable.
WHY NOT A: MODIFY is a write privilege and is not required to read; SELECT plus traversal suffices.
WHY NOT B: SELECT does not need to be re-granted at the catalog level. The table-level SELECT is valid and is not overridden; it just needs the traversal privileges.
WHY NOT C: Metastore-level ALL PRIVILEGES is excessive and not the minimum; USE CATALOG and USE SCHEMA are the missing pieces.
WHY NOT E: USE SCHEMA is not implied by USE CATALOG; the user still needs USE SCHEMA on main.sales as a separate grant.