QuestionQ82

Understand Snowflake roles, and data access management

Which command would enable a user with the appropriate privileges to change a database's ownership?

Explanation

Snowflake transfers database ownership by granting the OWNERSHIP privilege to the target role with GRANT OWNERSHIP ON DATABASE ... TO ROLE .... Grants of all privileges do not transfer ownership.

Learn more

Community Discussion

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