Remarks
The
LOAD TABLE statement
reads files from the database server machine. To control access
to the file system using these statements, the
-gl command-line
switch allows you to control the level of database permission that
is required to use these statements.
level is
either:
- DBA – only users with
the
LOAD ANY TABLE, ALTER ANY TABLE or ALTER ANY OBJECT system privilege can
load data.
- ALL – all users can load data.
- NONE – data cannot be loaded.
You can use either uppercase and lowercase syntax for the options.
The default settings are all for servers
started with start_iq and dba for other servers. For consistency with earlier
versions, use the all value on all systems. The
all setting is used in the iqdemo.cfg and default.cfg configuration files.