A data governance administrator needs to delegate the ability to grant and revoke privileges on a Unity Catalog schema to a senior analyst. Which principals are authorized to perform this action?
Answer & explanation
Correct answer: D
WHY D: In Unity Catalog, privileges on a securable object can be granted or revoked by the metastore admin, the owner of that object, a user with the MANAGE privilege on the object, or the owner of the catalog or schema that contains the object. This is documented in the Unity Catalog privilege model.
WHY NOT A: MODIFY is a write-access privilege on data content; it does not confer the ability to manage access control grants on an object.
WHY NOT B: Account admins have broad capabilities, but the authority to grant privileges is also held by object owners and MANAGE-privilege holders; it does not belong to the account admin who created the metastore alone.
WHY NOT C: Workspace admins have administrative rights within their workspace, but privilege management in Unity Catalog rests with the metastore admin, object owners and users holding MANAGE, not with workspace admins as such.
WHY NOT E: USE CATALOG lets a user navigate into a catalog and reach objects within it; it does not authorize changing access-control grants on objects inside that catalog.