| Goal | Privileges User Needs |
|---|---|
| Create table (including error table) | CREATE TABLE privilege on the database or user in which the table is created. |
| Alter or drop table | DROP TABLE on the table or the database that contains the table. Additional privileges are required for altering a table to add or change a PI, security constraint column, or UDT column. |
| Drop or rename table | DROP TABLE on the table or on the database containing the table |
| Archive table | DUMP privilege on the database or table or you must be the owner of the table. If the table has security constraint columns, you must also have OVERRIDE DUMP privilege. |
| Copy table |
Copying security constraint tables is not supported.
|
| Restore table | CREATE TABLE privilege on the table being restored, or be an owner of the table. If the table has security constraint columns, you must also have OVERRIDE RESTORE privilege. |