A user is trying to transfer ownership of a view from role `role_a' to The user executes the following command: ALTER VIEW employee_view TRANSFER OWNERSHIP TO ROLE role_b; The command fails with an er

Question

Options

• AThe user does not have the OWNERSHIP privilege on the `employee_view' .
• BThe role `role b' does not exist.
• CThe user does not have the USAGE privilege on the database containing the `employee_view'.
• DThe user does not have the MANAGE GRANTS privilege on the schema containing the
• EThe role role_b' already owns the employee_view' .

• A
  42% (15)
• B
  19% (7)
• C
  8% (3)
• E
  31% (11)

Explanation

Transferring ownership in Snowflake requires two distinct privileges: you must own the object (A) and have MANAGE GRANTS to grant that ownership to another role (D). Without OWNERSHIP on employee_view, you have no authority over it; without MANAGE GRANTS, you cannot reassign ownership privileges to role_b - both gaps independently cause an "insufficient privileges" failure.

Why the distractors are wrong:

• B (role doesn't exist): A nonexistent role produces a "role not found" error, not an insufficient privileges error.
• C (no USAGE on database): USAGE lets you navigate/query objects but is not a required privilege for the TRANSFER OWNERSHIP operation itself.
• E (role_b already owns the view): This would cause a logical/redundancy error, not a privilege error, and it's uncommon for exams to test this edge case in this context.

Memory tip: Think "Own it + Manage it to move it" - you need OWNERSHIP on the object and MANAGE GRANTS to hand it off. These two always travel together for ownership transfers in Snowflake.

No community discussion yet for this question.