Question

A data engineer runs GRANT SELECT ON TABLE sales.transactions.orders TO `analyst_team`. When members of analyst_team try to query the table, they receive a permission error stating they lack access. The team confirms they have SELECT on the orders table. What is the most likely cause of the error?

Accepted Answer

The group lacks USE CATALOG on `sales` and/or USE SCHEMA on `sales.transactions`, which are required to access the table.

Answer

SELECT privileges must be granted at the metastore level before they can apply to individual tables.

Answer

The analyst_team group must be assigned as the owner of the orders table to run SELECT queries.

Answer

SELECT on a table automatically expires unless MODIFY is also granted on the same table.