Creating MobiLink users

MobiLink users are not the same as database users. Each type of user resides in a different namespace. MobiLink user IDs can match the names of database users, but there is no requirement that they match.

StepsTo add a MobiLink user to a remote database in Sybase Central:

  1. Connect to Sybase Central as described in “Connecting to the database in Sybase Central”.

  2. Open the MobiLink Users folder and select File>New>User from the Sybase Central menu.

  3. Enter a name for the MobiLink user.

    The name is supplied to the MobiLink synchronization server during synchronization. In production databases, each user name is usually added to the consolidated database, then provided to the individual user.

  4. Click Finish.

StepsTo configure MobiLink user properties in Sybase Central:

  1. Connect to Sybase Central as described in “Connecting to the database in Sybase Central”.

  2. Open the MobiLink Users folder, right-click the MobiLink user, and select

    Properties from the pop-up menu.

  3. Change the properties as needed.

StepsTo drop a MobiLink user in Sybase Central:

  1. Connect to Sybase Central as described in “Connecting to the database in Sybase Central”.

  2. Open the MobiLink Users folder, right-click the MobiLink user, and select

    Delete from the pop-up menu.

NoteDropping MobiLink users You must drop all subscriptions for a MobiLink user before you drop the user from a remote database.

Adding MobiLink users to the consolidated database

The consolidated database contains a table called ml_user that is used to authenticate the names of MobiLink users when a synchronization is requested. When you add a user to a remote database, you need to be sure that the user is also added to the ml_user table.

You can add users automatically by selecting the Automatic Addition of Users check box in the MobiLink Synchronization Server Options dialog box and then starting the server. You open this dialog box from the Utilities folder in the Database painter or Database Profiles dialog box. You can also start the server from a command prompt, passing it the -zu+ switch.

Any users defined in the remote database are added to the ml_user table in the consolidated database, as long as the script for the authenticate_user connection event is undefined. Typically the -zu+ switch is not used in a production environment. Names are usually added to the ml_user table in the consolidated database, then added to each of the remote databases. Each user is given a unique name and optional password.