In Unity Catalog, the group contractors holds a direct SELECT grant on the table hr.payroll.salaries. A security engineer must remove that group's access to the table. Which statement does this?
Choose an answer to check it. Afterward, select any option to review its explanation.
DENY is a real SQL statement, but it applies only to the legacy hive_metastore catalog and is not supported by Unity Catalog. Denial in Unity Catalog uses ABAC DENY policies (Beta), not this command.
BROWSE adds metadata visibility; granting it does not replace or remove the existing SELECT grant.
Transferring ownership would give the group all capabilities on the table, the opposite of removing access.
Unity Catalog access exists only through grants, so removing the direct SELECT grant with REVOKE removes the group's access to the table.
id q03571f3093