Question

A data analyst at your company is assigned several roles: FINANCE_READER, MARKETING_READER, and SALES_READER, none of which is a parent of the others in the role hierarchy. During a session, the analyst's current primary role is set to FINANCE_READER, but they need to run a single query that joins tables to which access is granted through all three separate roles. They do not want to repeatedly switch roles or create a new custom role. What is the most appropriate way to accomplish this?

Accepted Answer

Run USE SECONDARY ROLES ALL so the session can use the combined privileges of all roles granted to the user in addition to the primary role

Answer

Run USE ROLE FINANCE_READER and rely on Snowflake automatically inheriting privileges from all sibling roles

Answer

Ask an ACCOUNTADMIN to grant FINANCE_READER to MARKETING_READER and SALES_READER to form a hierarchy

Answer

Grant OWNERSHIP of all three tables to FINANCE_READER so the primary role can access them directly