An analyst accidentally granted SELECT on a sensitive table to the wrong group. Which ANSI SQL command should the administrator use to remove this privilege in Unity Catalog?

Question

Accepted Answer

B. REVOKE SELECT ON TABLE sensitive_table FROM GROUP wrong_group. In Unity Catalog, ANSI SQL `REVOKE` is the correct command to remove previously granted privileges. The syntax follows ANSI SQL standards: `REVOKE SELECT ON TABLE table_name FROM GROUP group_name`. The other options use non-existent SQL keywords (DELETE GRANT, DROP PRIVILEGE, REMOVE) that are not valid ANSI SQL commands for privilege management.

An analyst accidentally granted SELECT on a sensitive table to the wrong group. Which ANSI SQL command should the administrator use to remove this privilege in Unity Catalog?

Related Questions

Discussion