▪ SET SYNC USER NONE (in master): SYS_ADMIN_ROLE or SYS_SYNC_ADMIN_ROLE role
▪ SET SYNC USER NONE (in replica): Any local user
▪ SET SYNC USER ... IDENTIFIED BY (in replica): SYS_SYNC_ADMIN_ROLE role
Usage
Use the SET SYNC USER statement in a replica database to define the user name and password for the registration process (when the replica database is registered to the master database).
You cannot use the SET SYNC USER statement in a master database.
Note The SET SYNC USER statement is used for replica database registration only. Aside from registration, all other synchronization operations require a valid master user ID in a replica database. If you want to designate a different master user for a replica database, you must map the replica ID on the replica database with the master ID on the master database. For details, see Changing replica access to the master database.
Parameters, clauses, keywords, and variables
▪ master-user-name: A master user that has sufficient rights to execute the replica registration tasks. You can provide registration rights for a master user in the master database by designating the user with the SYS_SYNC_REGISTER_ROLE or the SYS_SYNC_ADMIN_ROLE by using the GRANT rolename TO user statement, see GRANT.
▪ NONE: After the registration has been successfully completed, you must reset the sync user to NONE. Otherwise, if a master user saves statements, propagates messages, or refreshes from or registers to publications, the following error message is returned:
User definition not allowed for this operation.
Example
SET SYNC USER myuser IDENTIFIED BY mypassword; SET SYNC USER NONE;