Snowflake permissions are time-dependent graph resolution
Use this demo to show how database future grants, schema overrides, object grants, and creation time combine into real production breakage.
Why Clients Care
A team can be βgreenβ at the database level and still lose access to the very next table because a schema-level future grant quietly changed after the pipeline was built.
Fast Demo Flow
Run Setup Environment once to create roles, schemas, and Snowflake wiring.
Open any page and click Run All Steps to watch real SQL execute live.
Use the Grant Source column plus the MIT Event Feed to explain exactly why access changed.
Real business scenarios you can demo live
64-Case Permission Matrix
Click any cell for a quick classifier.
Resolution Rules
Precedence
Role Hierarchy
Granting a table to R1 makes it effectively visible to R1, R2, and R3. Granting a table to R2 does not restore visibility back to R1.
Detection Rules
Environment Activity
Real Snowflake setup and cleanup output.