| Object Type | Required Access Rights | ||
|---|---|---|---|
| Backup | Restore | Copy | |
| Aggregate Function | Dump | Restore, Alter Function | Restore, Alter Function |
| JAR | Dump | Restore, Drop Procedure | Restore, Drop Procedure |
| External Stored Procedures | Dump | Restore, Alter External Procedure | Restore, Alter External Procedure |
| Standard Function | Dump | Restore, Alter Function | Restore, Alter Function |
| Function Alias as of Analytics Database 16.20 Feature Update 1 |
Dump | Restore, Alter Function | Restore, Alter Function |
| Trigger | Dump | Restore | N/A Triggers can’t be copied |
| Join Index | Dump | Restore, Drop Table, Create Table, | Restore, Drop Table |
| Macro | Dump | Restore | Restore |
| Hash Index | Dump | Restore, Drop Table, Create Table | Restore, Drop Table |
| Stored Procedure | Dump | Restore | Restore |
| Queue Table | Dump | Restore | Restore |
| Table Function | Dump | Restore, Alter Function | Restore, Alter Function |
| Table Function (Operator) | Dump | Restore, Alter Function | Restore, Alter Function |
| Table | Dump | Restore, Drop Table, Create Table | Restore |
| PPI Table | Dump | Restore, Drop Table, Create Table | Restore, Drop Table |
| NOPI Table | Dump | Restore, Drop Table, Create Table | Restore |
| View | Dump | Restore | Restore |
| Authorization | Dump | Restore | Restore |
| Parser Contract Function | Dump | Restore | Restore |
| System Join Index | Dump | Restore, Drop Table, Create Table | Restore, Drop Table |
| SQL-H | Dump | Restore | Restore |
| User Installed File (UIF) | Dump | Restore, Create External Procedure, Execute Procedure on the SYSUIF database is required | Restore, Create External Procedure, Execute Procedure on the SYSUIF database is required |
| GLOP Set | Dump | Restore | Restore |