Which SQL command should be used to transfer ownership of the SAMPLE_DB database?
SAMPLE_DB
In Snowflake, ownership of a database is transferred with GRANT OWNERSHIP ON DATABASE ... TO ROLE .... Ownership is a special privilege that transfers control of the object to the receiving role; granting ALL, USAGE, or SYSADMIN does not itself transfer database ownership.
GRANT OWNERSHIP ON DATABASE ... TO ROLE ...
ALL
USAGE
SYSADMIN
Community Discussion