|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.
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.