SnowPro Core Certification — Question 316

What privilege should a user be granted to change permissions for new objects in a managed access schema?

Answer options

• A. Grant the OWNERSHIP privilege on the schema.
• B. Grant the OWNERSHIP privilege on the database.
• C. Grant the MANAGE GRANTS global privilege.
• D. Grant ALL privileges on the schema.

Correct answer: A

Explanation

The correct answer is A because granting the OWNERSHIP privilege on the schema allows the user to manage permissions for objects within that schema. Options B, C, and D do not provide the necessary control over permissions for new objects in a managed access schema.