Question

A data engineer needs to give the analytics team read access to every current and future table across all schemas within the catalog named 'sales_prod'. They want to configure this with a single grant that automatically applies to objects created later, without granting access to other catalogs in the metastore. Which action should they take?

Accepted Answer

GRANT SELECT ON CATALOG sales_prod TO `analytics_team`

Answer

GRANT SELECT ON METASTORE TO `analytics_team`

Answer

Run GRANT SELECT ON TABLE for each existing table in every schema of sales_prod

Answer

GRANT USAGE ON CATALOG sales_prod TO `analytics_team`