Snowflake
COF-C02 · Question #208
What privilege should a user be granted to change permissions for new objects in a managed access schema?
The correct answer is C. Grant the MANAGE GRANTS global privilege. To change permissions for new objects in a managed access schema, a user should be granted the MANAGE GRANTS global privilege. This privilege allows the user to manage access control through grants on all securable objects within Snowflake.
Account Access and Security
Question
What privilege should a user be granted to change permissions for new objects in a managed access schema?
Options
- AGrant the OWNERSHIP privilege on the schema.
- BGrant the OWNERSHIP privilege on the database.
- CGrant the MANAGE GRANTS global privilege.
- DGrant ALL privileges on the schema.
How the community answered
(28 responses)- A7% (2)
- B4% (1)
- C89% (25)
Explanation
To change permissions for new objects in a managed access schema, a user should be granted the MANAGE GRANTS global privilege. This privilege allows the user to manage access control through grants on all securable objects within Snowflake.
Topics
#Access Control#Managed Access Schemas#MANAGE GRANTS Privilege#Security
Community Discussion
No community discussion yet for this question.