Sun.Jan 01, 2023

article thumbnail

Snowflake: Database Role

Cloudyard

Read Time: 4 Minute, 18 Second During this post we will discuss the significance of Database role in snowflake. Scenario 1: Consider a scenario there is SALES_ANALYST Account role exists in our Snowflake Account. This Role is authorized to have access on Database SALES_DB, Schema inside the DB, and all respective tables. To allow access on SALES_DB, will run the below GRANT commands accordingly.