5. Populating Tables : COPY Statement Operation : Copy Permissions and Integrities
 
Share this page                  
Copy Permissions and Integrities
The COPY statement requires permission to access the table being copied. At least one of the following must apply:
You own the table.
You have been granted COPY INTO or COPY FROM privilege on the table.
The table has COPY INTO or COPY FROM permission granted to public.
To copy data in and out of the database as quickly as possible, the COPY statement does not check for:
Permissions other than COPY INTO or COPY FROM as described above
Integrities
When copying data into a table, copy ignores any QUEL integrity constraints (defined with the CREATE INTEGRITY statement) against the table.
Constraints
When copying data into a table, COPY ignores ISO Entry SQL92 check and referential constraints (defined using the CREATE TABLE and ALTER TABLE statements), but does not ignore unique and primary key constraints.
Rules
The COPY statement does not fire any rules defined against the table.
For information on integrities, constraints, and rules, see the chapter “Ensuring Data Integrity.”