-gd iqsrv15 server option

Sets the permissions required to start or stop a database on a running database server.

Syntax

iqsrv15 -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. 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.

Default

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

Applies to

All operating systems and database servers.

This option does not apply to servers in the cloud.

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.

When the option is set to DBA, the client application must use an existing DBA connection to another database running on the same server to start and stop databases. Simply having a connection to the server 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.

Example

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

Start the network database server:
```
iqsrv15 -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 'iqdemo.db';
```

Connect to the database:

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