SnowPro Advanced Administrator ADA-C02

The future OWNERSHIP grant on tables in PROD.WORKING makes PROD_WORKING_OWNER the owner of newly created table XYZ, and ownership provides control to alter or drop it. Privileges granted to a role are inherited by roles higher in its hierarchy; therefore SYSADMIN, which receives PROD_WORKING_OWNER, and ACCOUNTADMIN, which is higher in the system role hierarchy, can also alter or drop the table. SECURITYADMIN does not receive this ownership privilege.