QuestionQ62

Understand Snowflake roles, and data access management

Which table privilege is necessary to use the UNDROP command with Time Travel?

Explanation

Restoring a dropped table with UNDROP TABLE is an object-control operation; it requires the OWNERSHIP privilege on the table, rather than DML privileges such as DELETE, INSERT, or UPDATE.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!