How do you solve the one-role-at-a-time dilemma? 

Whether you are new or a veteran to Snowflake, you most likely have been frustrated with only being able to use one role at a time, while battling the complexity of role inheritance and managing object grants. Let us introduce you to a whole new way to work with Snowflake’s Role-Based Access Control (RBAC) with:

• User Synthetic Roles (USR) - Role per user
• Subject Primitive Roles (SPR) - Data set building blocks
• Masking Primitive Roles (MPR) - Dynamic Masking Roles for sensitive and classified data
• Warehouse Primitive Roles (WPR) - Warehouse roles
• Options on how to integrate with your IdM and automate the whole thing process