SnowPro Advanced Architect

DEV_PROJ_OWN owns DEV_TEST_DB.SCHTEST.CURRENCY, so it has the privilege to query the table. ACCOUNTADMIN is above DEV_PROJ_OWN in the role hierarchy and therefore inherits that role's privileges. In a managed access schema, owning the schema allows the schema owner to manage grants but does not automatically give another role SELECT access to a table owned by DEV_PROJ_OWN; similarly, DEV_PROJ_OWN cannot grant SELECT on the table to ANALYST_PROJ unless it is the schema owner or has MANAGE GRANTS.