|To...||the user must have the...|
|create a table (including error table)||CREATE TABLE privilege on the database or user in which the table is created.|
|alter or drop a 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 a table||DROP TABLE on the table or on the database containing the table|
|archive a 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 a table||the following privileges:
Copying of security constraint tables is not supported.
|restore a 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.