Which combination of primary and secondary roles can a Snowflake user configure in a session to access objects?
A Snowflake session must have exactly one active primary role at a time, while any number of secondary roles can be active concurrently. The active roles provide the combined privileges used to authorize applicable object-access actions.
Community Discussion