solidDB has two special roles for performing synchronization operations:
▪ SYS_SYNC_ADMIN_ROLE
This is an administration role for performing Advanced Replication data synchronization operations, such as deleting messages. Anyone with this privilege has all synchronization roles granted automatically.
▪ SYS_SYNC_REGISTER_ROLE
This is a role only for registering or unregistering a replica database to the master.
SYS_SYNC_ADMIN_ROLE automatically includes the SYS_SYNC_REGISTER_ROLE.
To grant these roles, use the GRANT statement in the master database, see GRANT.
Note After a user role is granted, it takes effect when the user who is granted the role logs on to the database. If the user is already logged on to the database, the user must disconnect and then reconnect to the database for the role to take effect.