solidDB®’s two special roles for performing synchronization operations are:
▪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 following syntax of the GRANT statement in themaster database:
GRANTrole_nameTOuser_name
Note Once 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.