A user wants to create objects within a schema but wants to restrict other users’ ability to grant privileges on these objects.
What configuration should be used to create the schema?
A user wants to create objects within a schema but wants to restrict other users’ ability to grant privileges on these objects.
What configuration should be used to create the schema?
To restrict other users' ability to grant privileges on objects within a schema, a managed access schema should be used. Managed access schemas allow the schema owner to control privilege grants on the objects within the schema, ensuring that only the designated users can grant privileges. This provides tighter security and control over the objects within the schema.
https://docs.snowflake.com/en/user-guide/security-access-control-privileges