-gd database server option

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

DBA Only users with the SERVER OPERATOR system privilege can start or stop databases.
all All users can start or stop databases. Not recommended for network servers that can be accessed by remote clients.
none Starting and stopping databases isn't allowed except when the database server itself is started and stopped.

The default setting is all for the personal database server.

The default setting is DBA for the network database server. Both uppercase and lowercase syntax are allowed.

All operating systems and database servers.

This option specifies the level of privilege required for a user to cause a new database file to be loaded by the database server, or to stop a database on a running database server.

When the option is set to DBA, the client application must use an existing connection to another database running on the same server to start and stop databases. You cannot start a database that is not already running by using the DatabaseFile connection parameter.

You can obtain the setting of the -gd option using the StartDBPermission server property:

SELECT PROPERTY ( 'StartDBPermission' );

The privileges for stopping a database server are specified by the -gk option.

The following steps illustrate how to use the -gd option for the network database server.

Start the network database server:
dbsrv16 -su mypwd -gd DBA -n my_server
Connect to the utility database from Interactive SQL:
dbisql -c "UID=DBA;PWD=mypwd;DBN=utility_db"
Start a database:
START DATABASE 'demo.db;';

Connect to the database:

CONNECT USING 'DBN=demo;UID=DBA;PWD=sql';

-gd database server option

Syntax

Allowed values

Default

Applies to

Remarks

See also

Example