Question

A data engineering team creates dozens of new tables in the ANALYTICS schema each week. The security administrator wants the REPORTING role to automatically have SELECT privileges on every table created in that schema going forward, without manually granting access to each new table. Which command accomplishes this?

Accepted Answer

GRANT SELECT ON FUTURE TABLES IN SCHEMA analytics TO ROLE reporting;

Answer

GRANT SELECT ON ALL TABLES IN SCHEMA analytics TO ROLE reporting;

Answer

GRANT SELECT ON SCHEMA analytics TO ROLE reporting;

Answer

GRANT OWNERSHIP ON SCHEMA analytics TO ROLE reporting;