QuestionQ57Verified/Account Management & Data GovernanceCopy linkReport a problemAsk AstroTutorSave questionHow can a user work with several assigned roles without having to switch roles frequently?AUse secondary roles and primary roles.BGrant the user the ACCOUNTADMIN role.CGrant the user the parent role of the roles that have been assigned.DCreate a new role and grant it to the user, then grant the existing roles to the new role.Show AnswerAnswerExplanationSnowflake can activate secondary roles alongside the active primary role, allowing most SQL actions to use the aggregate privileges of all active roles in the session. This reduces the need to repeatedly change the primary role. Object creation remains authorized by the primary role. Overview of Access ControlLearn moreSnowflake Documentation — Overview of Access ControlSnowflake Documentation — USE SECONDARY ROLESShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion