Question

A data engineer previously granted the 'analysts' group the SELECT privilege on the table sales.public.transactions. Compliance now requires that the 'analysts' group no longer be able to query this table. The engineer confirms the group has no other privileges that would grant access. Which SQL statement should the engineer run in Unity Catalog to remove this access?

Accepted Answer

REVOKE SELECT ON TABLE sales.public.transactions FROM `analysts`

Answer

DENY SELECT ON TABLE sales.public.transactions TO `analysts`

Answer

DROP SELECT ON TABLE sales.public.transactions FROM `analysts`

Answer

ALTER TABLE sales.public.transactions REMOVE GRANT SELECT FOR `analysts`