Snowflake Tutorial - Role, Grants & Role Hierarchy In Snowflake | Chapter-20 | Snowflake Hands-on Tutorial

Role, Grants & Role Hierarchy in snowflakes is such an important topic and every snowflake engineer must understand it. This episode is a comprehensive & practical guide with hands-on to demonstrate to you how role, role hierarchy, default role & secondary role work in snowflake. This guide will help you to answer the following questions 1. How RBAC & DAC work in snowflake? 2. How many default roles are there in snowflake? 3. How to setup role hierarchy in snowflake? 4. Most powreful role in snowflake? 5. What is the purpose of secondary role in snowflake? So enjoy this video series and provide your valuable feedback. 🌐 Site: https://toppertips.com 🌐 SQL Scripts https://toppertips.com/role-grants-role-hierarchy-example-ch20 🚀 🚀 Chapters 🚀 🚀 ----------------------------------------- ➥ 00:00 Role, Grants & Access Control in Snowflake? ➥ 03:01 Episode-20 Introduction ➥ 03:46 Why to subscribe to this channel ➥ 04:40 User Creation & Default Role ➥ 09:33 Granting roles to a user ➥ 13:46 Theory: What is DAC and how it works ➥ 16:03 DAC handson excercise ➥ 18:57 Theory: How RBAC Works ➥ 20:35 RBAC & DAC Simple Use Case ➥ 22:55 RBAC + DAC - how it works together - handson ➥ 37:50 Theory: What is the purpose of secondary role ➥ 39:57 Secondary role handson ➥ 43:31 Default roles in snowflake ➥ 44:50 How to protect your data from superuse ➥ 45:10 Thank you note & Disclaimer 🚀 🚀 Snowflake Tutotorials (Beginners) All Episodes 🚀🚀 --------------------------------------------------------------------------------------------------- ➥ Chapter 1-to-25 "Complete Playlist" 🌐 https://bit.ly/3iNTVGI ➥ Chapter-1 Snowflake Introduction & History 🌐 https://bit.ly/3xKHrna ➥ Chapter-2 Snowflake Free Trial Registration 🌐 https://bit.ly/3m6uiCL ➥ Chapter-3 Snowflake Architecture 🌐 https://bit.ly/3sk2fB2 ➥ Chapter-4 Snowflake Classic or Legacy WebUI 🌐 https://bit.ly/3stSyzS ➥ Chapter-5 Snowflake SnowSight Modern WebUI 🌐 https://youtu.be/T-l_LN_505Q ➥ Chapter-6 Snowflake Unique Features 🌐 https://youtu.be/-MZrCpoAUs0 ➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐 https://youtu.be/Pi3z1NyBd-Y ➥ Chapter-8 Snowflake Must Know Database Objects 🌐 https://youtu.be/S5NwU2o2Exg ➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐 https://youtu.be/lI5OQPjuj-8 ➥ Chapter-10 Snowflake Continuous Data Loading 🌐 https://youtu.be/PNK49SJvXjE ➥ Chapter-11 Snowflake External Table 🌐 https://youtu.be/w9BQsOlJc5s ➥ Chapter-12 Snowflake Virtual Warehouse 🌐 https://youtu.be/NE07Jx6V4UA ➥ Chapter-13 Snowflake Micro Partition 🌐 https://youtu.be/UNBysn1M9Vg ➥ Chapter-14 Snowflake Time Travel 🌐 https://youtu.be/9k8ADXunhIk ➥ Chapter-15 Snowflake Clone Feature 🌐 https://youtu.be/cAyM-Nj9WOc ➥ Chapter-16 Snowflake Secure Data Sharing 🌐 https://youtu.be/2d6d-zZMXtA ➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐 https://youtu.be/DXI0GDSwE_E ➥ Chapter-18 Snowflake Task & Task Tree 🌐 https://youtu.be/165hXZ_o4Vk ➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐 https://youtu.be/9FejjGVZrPg ➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐 https://youtu.be/pZQXK7qO0iY ➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐 https://youtu.be/CsH2sB6gwlw ➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐https://youtu.be/xnjCbgu0Qj4 ➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 https://youtu.be/2soTybOZkXY ➥ Chapter-22 Snowflake Information Schema 🌐 https://youtu.be/kqZRXoFcKo0 ➥ Chapter-23 Snowflake Resource Monitor 🌐 https://youtu.be/2msEUDzp-uU ➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐 https://youtu.be/tzbqj2y_cbw ➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐 https://youtu.be/X4uXkGS0dUQ ➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐 https://youtu.be/ZrhTYKuGFbo ➥ Chapter-25 (Part-1) Snowflake & PowerBI Reporting 🌐 coming-soon ➥ Chapter-25 (Part-2) Snowflake & Tableau Reporting 🌐 coming-soon 🚀 🚀 Snowflake Certification Complete Guide & Question Dump 🚀 🚀 ----------------------------------------------------------------------------------------------------------------- ➥ Revised Sep 2020 Syllabus: https://youtu.be/jhNoKeB0CVY ➥ SnowPro Guide: https://bit.ly/35S7Rcb ➥ SnowPro Practice Test (60 Questions): https://bit.ly/2Ubernv #SnowflakeRoles #AccessPrivilegesInSnowflake #snowflakecomputing #securedatasharing #deltaloadsnowflake