D1.3 - DEFINE THE ENTITIES AND ROLES THAT ARE USED IN SNOWFLAKE

Question 1

How are privilege’s granted and revoked in Snowflake?

Answer 1

Privilleges are granted and revoked using the GRANT and REVOKE commands

Question 2

Explain role hierarchy

Answer 2

TOP: ACCOUNTADMIN
MID: SECURITYADMIN & SYSADMIN
LOW: USERADMIN & CUSTOM ROLES
LOWEST: PUBLIC

Question 3

Explain privilege’s inheritance

Answer 3

ROLE_1 –> P_B + P_C + P_A
ROLE_2 –> P_B + P_C
ROLE_3 -> P_C