Contents Index -gc server option -ge server option

ASA Database Administration Guide
  The Database Server
    The database server
      Database server options

-gd server option

Function 

Set permissions required to start or stop a database.

Syntax 

dbsrv9 | dbeng9 } -gd { DBA | all | none } ...

Applies to 

All operating systems and servers.

Description 

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:

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 in order to start or stop a database. Providing a DBA username and password on a new connection is not sufficient.

Example 

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

  1. Enter a password in the util_db.ini file in the directory that holds the database server executable:

    [UTILITY_DB]
    pwd=mypwd
  2. Start the network database server:

    dbsrv9 -x tcpip -n myserver -gd DBA
  3. Connect to the utility database from Interactive SQL.

    The following command assumes that myserver is the default database server:

    dbisql -c "uid=DBA;pwd=mypwd;dbn=utility_db "
  4. Start a database:

    start database asademo
    on myserver;
  5. Connect to the database you have started:

    connect
    to myserver
    database asademo
    user DBA identified by SQL

Contents Index -gc server option -ge server option