Which access-control policy takes effect when future grants are assigned to both database-level and schema-level objects?
For future grants on the same object type in a database and one of its schemas, Snowflake applies the schema-level grants and ignores the database-level grants for that schema. Snowflake documentation
Community Discussion