Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » The database server » Database server options


-gd server option

Sets the permissions required to start or stop a database.

{ dbsrv11 | dbeng11 } -gd { DBA | all | none } ...
Applies to

All operating systems and database servers.


This is the permission required for a user to cause a new database file to be loaded by the server, or to stop a database on a running database server. The level can be one of the following:

  • 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 apart from when the database server itself is started and stopped.

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

Note that when this option is set to DBA, the client application must already have a connection to the 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' );
See also

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

  1. Start the network database server:

    dbsrv11 -x tcpip -su mypwd -n myserver -gd DBA
  2. Connect to the utility database from Interactive SQL:

    dbisql -c "UID=DBA;PWD=mypwd;ENG=myserver;DBN=utility_db"
  3. Start a database:

    ON myserver;
  4. Connect to the database you have started:

    TO myserver
    DATABASE demo