SOL-C01 Question #67: Real Exam Question with Answer & Explanation

Question

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 error indicating insufficient privileges. Which of the following could be the reason(s) for the failure? (Select all that apply)

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' .

Explanation

To transfer ownership, the user executing the command must have the OWNERSHIP privilege on the object and the MANAGE GRANTS privilege on the schema containing the object. If does not exist, or already owns the object, a different error would be raised. While USAGE on the database might be required for other operations, it is not a direct requirement for transferring ownership if the user has OWNERSHIP and MANAGE GRANTS.

No community discussion yet for this question.