Granting Access to a Role on newly created schema's automatically without manual intervention

Forget Snowflake, this cannot be achieved in any database. And its not a secure practice.

If you still want to do it. 

1. You will need to manually check every 5 mins (or whatever interval is comfortable for you) for all the schemas that are newly created

2.And apply the grants to them

You can write a simple unix script utilizing snowsql commands to achieve this. You can then schedule this unix script to run using a cron scheduler or any other scheduler that your company uses

Thank you for the details, this helps. Really appreciate it.