SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ1

Manage and administer Snowflake accounts, data security, and governance

The following commands have been run:

Grant usage on database PROD to role PROD_ANALYST;  
Grant usage on database PROD to role PROD_SUPERVISOR;  
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;  
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;  
Grant role PROD_ANALYST to user A;  
Grant role PROD_SUPERVISOR to user B;

What authority does each user have on the WORKING schema?

Explanation

In Snowflake, privileges are granted to roles and inherited by users assigned those roles. Both roles have database USAGE and all schema-level privileges on PROD.WORKING, including the privilege to create tables. Schema privileges do not by themselves grant access to existing tables or tables created by another role.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!