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