nzload command privileges

To run the nzload command, you must have the Create External Table privilege and access privileges on the table or database: List, Insert, and Select.

If you issue the nzload command from the system host and you are not the nz user, you must do one of the following tasks:

Ensure that the GROUP nz has Read permissions for the data file to load.
Specify the -host option for the nzload command, for example, nzload -host <hostname>).

For more information, see the IBM® Netezza® System Administrator’s Guide.