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: D

Explanation:

Reference: https://docs.snowflake.com/en/sql-reference/sql/drop-role.html