問題文
A retail analytics team owns a table in a database that was created by a role outside the hierarchy of the account administrator. An administrator using ACCOUNTADMIN opens a worksheet and tries to alter that table, and the statement is rejected. What explains this outcome?
選択肢
- Privileges reach an object through ownership or an explicit grant somewhere in the current role's hierarchy, so a table owned outside that hierarchy stays out of reach.
- Ownership transfers to the account administrator automatically once a table has existed for a full retention period, and that transfer had not completed yet.
- The account administrator role can act on every object in the account, so the rejection must come from a network policy that is blocking the worksheet session at that moment.
- Altering a table requires the security administrator role, which owns the operations that Snowflake classifies as security changes.