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

 

-su server option

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

Syntax
{ dbsrv11 | dbeng11 } -su password ...
Applies to

All operating systems and database servers.

Remarks

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. To avoid having the utility database password in clear text on the command line, you can use dbfhide to obfuscate a file containing the password, and then reference the obfuscated file on the command line.

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. 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. Note that the util_db.ini file is deprecated.

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.

See also
Example

The following command disables all connections to the utility database:

dbeng11 -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:

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