-gl database server option

dbsrv16 -gl { DBA | all | none } ...

DBA For unloading data, you must have the SELECT ANY TABLE system privilege.
For loading data, you must have the LOAD ANY TABLE, ALTER ANY TABLE, or ALTER ANY OBJECT system privilege.
all For unloading data, you must be the owner of the tables, or have SELECT privilege on the tables, or have the SELECT ANY TABLE system privilege.
For loading data, one of the following must be true:
- You are the owner of the table
- You have LOAD privilege on the table
- You have the LOAD ANY TABLE system privilege
- You have the ALTER ANY TABLE system privilege
- You have the ALTER ANY OBJECT system privilege
none Data cannot be unloaded or loaded.

The default setting is all for personal database servers on Windows and DBA for the personal server on Unix.

The default settings reflect the fact that, on non-Unix platforms, the personal database server is running on the current computer, so the user already has access to the file system.

The default setting is DBA for the network database server.

All operating systems and database servers.

Using the UNLOAD TABLE or UNLOAD statement places data in files on the database server computer, and the LOAD TABLE statement reads files from the database server computer.

To control access to the file system using these statements, the -gl server option allows you to control the privileges required to use these statements.

Both uppercase and lowercase syntax are acceptable.

-gl database server option

Syntax

Allowed values

Default

Applies to

Remarks

See also