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.
To add a MobiLink user to a remote database in SQL
Central:
-
Connect to SQL Central as described in Connecting to the database in
SQL Central. -
Open the MobiLink Users folder and select File>New>User
from the SQL Central menu. -
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. -
Click Finish.
To configure MobiLink user properties in SQL Central:
-
Connect to SQL Central as described in Connecting to the database in
SQL Central. -
Open the MobiLink Users folder, right-click the MobiLink user,
and select Properties from the pop-up menu -
Change the properties as needed.
To drop a MobiLink user in SQL Central:
-
Connect to SQL Central as described in Connecting to the database in
SQL Central. -
Open the MobiLink Users folder, right-click the MobiLink user,
and select Delete from the pop-up menu.
Dropping 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.