Setting up Snowflake — the exact grant statements we run

Archive
21

Hey @claire! I just wanted to double-check the grants in section 7 for an existing analytics database. Should the last 2 lines grant to the role ‘reporter’ rather than ‘transformer’, in line with the rest of the section?

grant usage on all schemas in database analytics to role reporter;
grant select on all tables in database analytics to role reporter;
grant select on all views in database analytics to role reporter;

Thanks!

1 Like