Users in the Contact sample

Several different database user IDs and MobiLink user names are included in the Contact sample.

Database user IDs

The two remote databases belong to sales representatives Samuel Singer (rep_id 856) and Pamela Savarino (rep_id 949).

When connecting to their remote database, these users both use the default SQL Anywhere user ID dba and password SQL.

Each remote database also has a user ID sync_user with password sync_user. This user ID is employed only on the dbmlsync command line. It is a user with REMOTE DBA authority, and so can perform any operation when connected from dbmlsync, but has no authority when connected from any other application. The widespread availability of the user ID and password is thus not a problem.

At the consolidated database, there is a user named mlmaint, who owns the tables used for monitoring MobiLink synchronization statistics and errors. This user has no right to connect. The assignment of the tables to a separate user ID is done simply to separate the objects from the others in the schema for easier administration in Sybase Central and other utilities.

MobiLink user names

MobiLink user names are distinct from database user IDs. Each remote device has a MobiLink user name in addition to the user ID they use when connecting to a database. The MobiLink user name for Samuel Singer is SSinger. The MobiLink user name for Pamela Savarino is PSavarino. The MobiLink user name is stored or used in the following locations:

  • At the remote database, the MobiLink user name is added using a CREATE SYNCHRONIZATION USER statement.
  • At the consolidated database, the MobiLink user name and password are added using the mluser utility.
  • During synchronization, the MobiLink password for the connecting user is supplied on the dbmlsync command line listed in MobiLink\Contact\step2.bat.
  • The MobiLink server supplies the MobiLink user name as a parameter to many of the scripts during synchronization.
  • The SalesRep table at the consolidated database has an ml_username column. The synchronization scripts match the MobiLink user name parameter against the value in this column.
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0