In this lesson we will learn about the Snowflake permission model, including users and roles, and how they are used to control access to various data within your databases.
As with many databases, Snowflake has a Role Based Access Control Model. Permissions to read or write certain tables are granted to roles, and roles are granted to people.
Exanple roles might be:
A particular set of permissions might be:
Roles are created using SQL
create role storemanager; create role storeemployee;
We then grant permissions to the manager role.
alter role storemanager add alter role storemanager add
alter user benjamin grant role manager
In this lesson we looked at the Snowflake permission model.