Access Privileges
The COPY statement requires these access privileges for database-level and table-level objects:
The target database must also exist before making the copy.
To Copy a UIF object, the user named in the LOGON statement must have
Note: You are not cannot grant the RESTORE privilege on the UIF object itself, but with the database-level RESTORE privilege, you can do a table-level copy of the individual UIF object.