Siebel Remote and Replication Manager Administration Guide > Implementing Siebel Remote Server >

Changing the Local Database Administrator Password

In some cases, you may want to change the local DBA password on Mobile Web Clients. To accomplish this task, you should change the DBA password in the database template file before generating the new database template.

The following procedure shows how to accomplish this task in the SQL Anywhere environment.

To change the local DBA password on Mobile Web Clients

  1. In a DOS window on the server machine, run the Interactive SQL utility: dbisqlc.exe.
    1. At the DOS prompt, change to the \bin subdirectory within the Siebel server root directory:

    cd \siebel_server_root\bin

    1. Run dbisqlc.exe by entering:

    dbisqlc -c "UID=DBA;PWD=SQL;DBF=siebel\dbtempl\my_templ.dbf"

  2. In the Command window, enter:

    grant connect to user_id identified by new_password

    For example, to set a new password of SQL2 for the user DBA, enter:

    grant connect to DBA identified by SQL2

    NOTE:  You must use uppercase for every password in SQL Anywhere.

  3. Click Execute.
  4. Run the Generate New Database component using the new DBA password.

    For information on running the Generate New Database component, see Generating a New Database Template.

  5. Run a Database Extract for Mobile Web Clients, and notify mobile users to initialize their databases.

    For information about initializing a local database, see Initializing a Mobile Web Client Database.


 Siebel Remote and Replication Manager Administration Guide 
 Published: 19 November 2003