How can a user transfer ownership of a database to a different role?
Snowflake 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;.
OWNERSHIP
GRANT OWNERSHIP ON DATABASE db_name TO ROLE new_role;
Community Discussion