ASA Database Administration Guide
The Database Server
The database server
Database server options
Set the permission required to load data using LOAD TABLE, and to unload data using UNLOAD or UNLOAD TABLE.
{ dbsrv9 | dbeng9 } -gl { DBA | all | none } ...
All operating systems and servers.
Using the UNLOAD TABLE or UNLOAD statements places data in files on the database server machine, and the LOAD TABLE statement reads files from the database server machine.
To control access to the file system using these statements, the -gl
server option allows you to control the level of database permission that is required to use these statements.
The allowed values are as follows:
DBA Only users with DBA authority can load or unload data from the database.
all All users can load or unload data from the database.
none Data cannot be unloaded or loaded.
Both uppercase and lower case syntax is acceptable.
The default settings are all for personal database servers on non-UNIX operating systems, and DBA for the network database server and the UNIX personal server. These settings reflect the fact that, on non-UNIX platforms, the personal database server is running on the current machine, and so the user already has access to the file system.