A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?
A . The tables are now orphaned
B. The user that deleted the role
C. SYSADMIN
D. The assumed role that dropped the role

View Answer

Answer: A

Explanation:

When a role is dropped in Snowflake, any objects owned by the role, such as tables, become orphaned. Orphaned objects cannot be accessed or altered by any user or role until ownership is transferred to an existing role. To transfer ownership, a user with the appropriate privileges (typically a user with the ACCOUNTADMIN or SECURITYADMIN role) can use the ALTER command to change the object’s ownership: ALTER TABLE table_name SET OWNER_ROLE = new_owner_role;