Sets the permission required to load data using LOAD TABLE, and to unload data using UNLOAD or UNLOAD TABLE.
{ dbsrv11 | dbeng11 } -gl { DBA | all | none } ...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 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 lowercase syntax is acceptable.
The default setting is 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 computer, and so the user already has access to the file system.
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |