Question

A data engineer needs to allow the 'etl_writers' group to insert, update, and delete rows in the table `sales.transactions.orders`, but the group should not be able to alter the table's schema or drop the table. The group already has USAGE on the catalog and schema and SELECT on the table. Which single privilege should be granted on the table to enable the required write operations?

Accepted Answer

GRANT MODIFY ON TABLE sales.transactions.orders TO `etl_writers`

Answer

GRANT ALL PRIVILEGES ON TABLE sales.transactions.orders TO `etl_writers`

Answer

GRANT MANAGE ON TABLE sales.transactions.orders TO `etl_writers`

Answer

GRANT CREATE TABLE ON SCHEMA sales.transactions TO `etl_writers`