ALTER SYNCHRONIZATION USER statement [MobiLink]

Syntax

ALTER SYNCHRONIZATION USER ml-username
[ TYPE network-protocol ]
[ ADDRESS protocol-options ]
[ ADD OPTION option=value, ... ]
[ ALTER OPTION option=value, ... ]
[ DELETE { ALL OPTION | OPTION option } ]

ml-username : identifier

network-protocol : http | https | tls | tcpip | NULL

protocol-options : string | NULL

value : string | integer

Parameters

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).
ADD OPTION, ALTER OPTION, DELETE OPTION, and DELETE ALL OPTION clauses
These clauses allow you to add, modify, delete, or delete all extended options. You may specify only one option in each clause. No option is specified for Delete All.

Remarks

The network-protocol, protocol-options, and options can be set in several places.

This statement causes options and other information to be stored in the ISYSSYNC system table. Depending on the privileges a user has, passwords and encryption certificates can be visible. To avoid this potential security issue, you can specify the information on the dbmlsync command line.

Requires exclusive access to all tables referred to in the publication.

Privileges

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Side effects

Automatic commit.

Standards

ANSI/ISO SQL Standard
Not in the standard.