Answer-first summary for fast verification
Answer: Use a managed access schema.
The question asks for a schema configuration that restricts other users' ability to grant privileges on objects within the schema. A managed access schema (option B) is specifically designed for this purpose - it centralizes privilege management so that only the schema owner (or roles with MANAGE GRANTS privilege) can grant privileges on objects within the schema. This prevents other users from granting privileges even if they have access to the objects. Option A (regular schema) allows any user with appropriate privileges to grant permissions to others. Option C (transient schema) relates to data persistence and recovery, not privilege management. Option D (Default_DDL_Collation) controls character set behavior, not privilege granting restrictions. The community discussion shows 100% consensus on option B, with references to Snowflake documentation confirming that managed access schemas provide the required privilege control.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A user wants to create objects within a schema but wants to restrict other users’ ability to grant privileges on these objects.
Which schema type should be used to create the schema?
A
Use a regular (non-managed) schema.
B
Use a managed access schema.
C
Use a transient schema.
D
Set the Default_DDL_Collation parameter.
No comments yet.