When a role is dropped, which role inherits ownership of objects owned by the dropped role?

When a role is dropped, which role inherits ownership of objects owned by the dropped role?
A . The SYSADMIN role
B . The role above the dropped role in the RBAC hierarchy
C . The role executing the command
D . The SECURITYADMIN role

View Answer

Answer: B

Explanation:

According to the Snowflake documentation1, when a role is dropped, ownership of all objects owned by the dropped role is transferred to the role that is directly above the dropped role in the role hierarchy. This is to ensure that there is always a single owner for each object in the system.

1: Drop Role | Snowflake Documentation