5.1.11 Executor

Organization of this subsection
(1) CONNECT privilege
(2) Access privilege

(1) CONNECT privilege

A user (authorization identifier specified in the -u option or the PDUSER environment variable) who will be executing pdload needs CONNECT privilege for HiRDB (because pdload connects to HiRDB when it retrieves table definition information subject to data loading from dictionaries).

(2) Access privilege

Basically, a table creator executes data loading.

To enable another user to perform data loading, you must grant the privileges shown below as appropriate to the data loading mode. Note that when data is to be loaded into an audit trail table and the HiRDB administrator executes the command, a message requesting entry of a password is displayed. In such a case, the auditor must enter the password.

Addition mode (-d option omitted)
A user with the INSERT privilege can perform data loading.
Creation mode (-d option specified)
A user with the INSERT and DELETE privileges can perform data loading.