Which privileges are required for a user to restore an object? (Choose two.)
Which privileges are required for a user to restore an object? (Choose two.)
To restore an object, a user must have OWNERSHIP privileges on the object and CREATE privileges on the object type within the database or schema where the object is to be restored. OWNERSHIP is essential to manage the object, while CREATE is needed to re-establish the object in the database.
Similar to dropping an object, a user must have OWNERSHIP privileges for an object to restore it. In addition, the user must have CREATE privileges on the object type for the database or schema where the dropped object will be restored.
Similar to dropping an object, a user must have OWNERSHIP privileges for an object to restore it. In addition, the user must have CREATE privileges on the object type for the database or schema where the dropped object will be restored. https://docs.snowflake.com/en/user-guide/data-time-travel
https://docs.snowflake.com/en/user-guide/security-access-control-privileges
B and E: Ownership and create. UNDROP is not a privilege according to the documentation. https://docs.snowflake.com/en/user-guide/security-access-control-privileges
Ownership and Create are the best choices if we are asked to select two options. https://docs.snowflake.com/en/user-guide/security-access-control-privileges
https://docs.snowflake.com/en/user-guide/data-time-travel#:~:text=Similar%20to%20dropping%20an%20object%2C%20a%20user%20must%20have%20OWNERSHIP%20privileges%20for%20an%20object%20to%20restore%20it.%20In%20addition%2C%20the%20user%20must%20have%20CREATE%20privileges%20on%20the%20object%20type%20for%20the%20database%20or%20schema%20where%20the%20dropped%20object%20will%20be%20restored.