-gd dbeng12/dbsrv12 server option

Sets the permissions required to start or stop a database.

Syntax

{ dbeng12 | dbsrv12 } -gd { DBA | all | none } ...

Allowed values

DBA Only users with DBA authority can start or stop databases.
all All users can start or stop databases.
none Starting and stopping databases isn't allowed except when the database server itself is started and stopped.

Remarks

This option specifies the level of permission 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.

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

When this option is set to DBA, the client application must already have a connection to the database server to start or stop a database. Providing a DBA user ID and password on a new connection is not enough.

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

SELECT PROPERTY ( 'StartDBPermission' );

The permissions for stopping a database server are specified by the -gk option. See -gk dbeng12/dbsrv12 server option.

Example

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

Start the network database server:
dbeng12 -su mypwd -gd DBA
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';

Discuss this page in DocCommentXchange.

-gd dbeng12/dbsrv12 server option

Syntax

Allowed values

Applies to

Remarks

See also

Example