Secondary Roles are a newer addition to the RBAC system in Snowflake. In the past few chapters, we’ve run into some limitations with how primary roles work, specifically for users that work cross-functionally and need to assume multiple roles. One of the solutions I mentioned was role inheritance, which we will cover in the next chapter. The other solution I mentioned is secondary roles.
At Pinterest, I was an early adopter of secondary roles. We had Snowflake connected to Tableau in such a way that users needed to authenticate ...
