CREATE SYNCHRONIZATION USER statement [MobiLink]

Creates a MobiLink user in a SQL Anywhere remote database.

Syntax

CREATE SYNCHRONIZATION USER ml-username
[ TYPE network-protocol ]
[ ADDRESS protocol-options ]
[ OPTION option=value, ... ]

ml-username : identifier

network-protocol : 
tcpip 
| http 
| https 
| tls

protocol-options : string

value : string | integer

Parameters

ml_username
A name identifying a MobiLink user.
TYPE clause
This clause specifies the network protocol to use for synchronization. The default protocol is tcpip.
ADDRESS clause
This clause specifies protocol-options in the form keyword=value, separated by semicolons. Which settings you supply depends on the communication protocol you are using (TCP/IP, TLS, HTTP, or HTTPS).
OPTION clause
The OPTION clause allows you to set extended options using option=value in a comma-separated list.

The values for each option cannot contain equal signs or semicolons. The database server accepts any option that you enter without checking for its validity. Therefore, if you misspell an option or enter an invalid value, no error message appears until you run the dbmlsync command to perform synchronization.

Options set for a synchronization user can be overridden in individual subscriptions or on the dbmlsync command line.

The network-protocol, protocol-options, and option settings can be overridden in other statements and contexts.

This statement causes options and other information to be stored in the SQL Anywhere ISYSSYNC system table. Anyone with the correct privileges to view the SYSSYNC system view can view the information, which could include passwords and encryption certificates. To avoid this potential security issue, you can specify the information on the dbmlsync command line.

Privileges

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Side effects

Automatic commit.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

The following example creates a MobiLink user named SSinger, who synchronizes over TCP/IP with a server computer named mlserver.mycompany.com using the password Sam. The use of a password in the user definition is not secure.

CREATE SYNCHRONIZATION USER SSinger
TYPE http
ADDRESS 'host=mlserver.mycompany.com'
OPTION MobiLinkPwd='Sam';