QuestionQ5Verified/Understand Snowflake roles, and data access managementCopy linkReport a problemAsk AstroTutorSave questionHow can a user transfer ownership of a database to a different role?AREVOKE OWNERSHIP ON DATABASE mydb FROM ROLE myrole;BGRANT USAGE ON DATABASE db_name TO ROLE new_role;CALTER DATABASE ROLE current_role RENAME TO new_role;DGRANT OWNERSHIP ON DATABASE db_name TO ROLE new_role;Show AnswerAnswerExplanationSnowflake transfers an object's ownership by granting the OWNERSHIP privilege to the receiving role. For a database, the command form is GRANT OWNERSHIP ON DATABASE db_name TO ROLE new_role;.Learn moreGRANT OWNERSHIP | Snowflake DocumentationShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion