We’ve covered the different role paradigms, whether functional or team, and we’ve addressed the different privileges Snowflake provides. We’ve discussed how we can draft roles so that they are manageable and scalable. Now we’re going to cover how we actually use these roles in practice.
Snowflake is based on role-based access control; all objects are owned by roles rather than by individual users. Privileges are granted to roles rather than directly to users. Users can switch between the different roles granted ...