Snowflake Shared Database Role | Rajiv Gupta Everyday Learning
Database Roles:
To limit SQL actions to a single database, as well as any object in the database, grant privileges on the object to a database role in the same database.
Note that database roles cannot be activated directly in a session. Grant database roles to account roles, which can be activated in a session.
Blog: / database-role-v-s-account-role-in-snowflake