-su database server option

Sets the password for the DBA user of the utility database (utility_db), or disable connections to the utility database.

Syntax

dbsrv16 -su password ...

This option specifies the initial password for the DBA user of the utility database. The password is case sensitive. You can specify none for the password to disable all connections to the utility database.

If you are using a personal database server and do not specify the -su option, connections to the utility database are allowed with the DBA user ID and any password. It is assumed that anyone who can connect to the personal database server can access the file system directly so no attempt is made to screen users based on passwords.
If you are using the network database server and do not specify the -su option, connections to the utility database are not allowed unless the util_db.ini file exists and the user ID is DBA with a password that matches the password in the util_db.ini file. On a network server, if both -su and util_db.ini are used, util_db.ini is ignored. The util_db.ini file is deprecated.

Specifying a password for the utility database for a network database server is useful for the cases when the database server is running, but it is not possible to connect to the database. For example, in a mirroring system, you can connect to the utility database to shut down the database server, or force a mirror server to become the primary server if necessary. See Stopping a database server in a mirroring system and Troubleshooting: The primary server cannot be restarted.

You can execute a CREATE USER DBA IDENTIFIED BY new-password statement while connected to utility_db to change the password for the DBA user of the utility database. The REVOKE CONNECT FROM DBA statement can be used to disable connections to the utility_db database. Not all SQL statements are supported for the utility database.

To avoid having the utility database password in clear text on the command line, you can use the dbfhide utility to obfuscate a file containing the password, and then reference the obfuscated file on the command line.

Example

The following command disables all connections to the utility database:

dbsrv16 -su none c:\inventory.db

In the following example, the file named util_db_pwd.cfg that contains the utility database password is obfuscated using dbfhide and renamed util_db_pwd_hide.cfg:

dbfhide util_db_pwd.cfg util_db_pwd_hide.cfg

The util_db_pwd_hide.cfg file can then be used to specify the utility database password:

dbsrv16 -su @util_db_pwd_hide.cfg -n my_server c:\inventory.db

Discuss this page in DocCommentXchange.

-su database server option

Syntax

Applies to

Remarks

See also

Example