How can a user work with several assigned roles without having to switch roles frequently?
Snowflake can activate secondary roles alongside the active primary role, allowing most SQL actions to use the aggregate privileges of all active roles in the session. This reduces the need to repeatedly change the primary role. Object creation remains authorized by the primary role. Overview of Access Control
Community Discussion