Is there a way to create objects in snowflake and other users automatically get privileges to modify obj's with schema owner role?

I know that using role hierarchy we can create on standard role for a schema and that role can be granted to user role and then user can go ahead and modify the objects using that role. I was just trying to explore options to see if there is a way we can make snowflake to automatically understand that you have access to the schema owner role and it can let you do any modifications to objects in the schema. Also by default the objects should be created using the schema owner role. Any thoughts, please little 'r' me?

nekkanti009

posted on 01 Feb 20