The COPY statement requires these access privileges for database-level and table-level objects:
- Create Macro (CM)
- Create Table (CT)
- Create View (CV)
- Restore (RS)
The target database must also exist before making the copy.
To Copy a UIF object, the user named in the LOGON statement must have
- The RESTORE privilege on the database targeted for the copy
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.