Working with Roles and Users in Snowflake

Documentation :
---------------------------
docs.snowflake...
docs.snowflake...
docs.snowflake...
Code:
--------
DROP database if exists ramu;
CREATE or replace database RAMU;
create or replace table ramu.PUBLIC.employee_info(employee_id number , employee_name varchar(200),
empl_password varchar(200),
dept varchar(10));
insert into ramu.PUBLIC.employee_info values(1,'Soham','Soham123','HR'),
(2,'Rajdeep','Raja456@','Marketing'),
(3,'Ranjith','Jiohi12','HR'),
(4,'Sudeshna','helloworld12','Support'),
(5,'Surojit','bmps123','BI'),
(6,'Sayan','jalo1i123','Management');
select * from ramu.PUBLIC.employee_info;
create OR REPLACE role demo_role_yt;
GRANT USAGE ON WAREHOUSE COMPUTE_WH TO demo_role_yt;
create user helloworlduser password='abc123' comment="User for testing RBAC" ;
GRANT ROLE demo_role_yt TO USER helloworlduser;
GRANT USAGE ON DATABASE RAMU TO demo_role_yt;
GRANT USAGE ON SCHEMA RAMU.PUBLIC TO demo_role_yt;
GRANT SELECT ON TABLE RAMU.PUBLIC.EMPLOYEE_INFO TO demo_role_yt;
GRANT ALL PRIVILEGES ON SCHEMA RAMU.PUBLIC TO demo_role_yt;
Check this playlist for more AWS Projects in Big Data domain:
• Demystifying Data Engi...

[@adithyasai8347]

Sir which by default which admin role will be given to developer

[@venkatg1221]

tq for info. Nice explanation

[@KnowledgeAmplifier1]

You are welcome Venkat G! Happy Learning

[@KSrikanth-gy2pe]

Great share.. thanks a lot..

[@KnowledgeAmplifier1]

Thank you so much for your kind words K Srikanth 1225! I'm glad you found it helpful 😊

[@moizdewaswala6717]

Thank you for sharing..Can I please request you to upload a video on Snowflake query tagging and various usecases for query tags

[@srikanthkundeti3920]

such a nice info

[@KnowledgeAmplifier1]

Glad you think so!

[@hridaysharma]

Bangali

[@KnowledgeAmplifier1]

Ha @hridaysharma