After you create your database schema, you need to determine:
▪ The local users on each replica database that need authorization to use specific tables in a publication, as well as execute rights to procedures they need to execute.
▪ The master users that need authorization to manage synchronized data in both the master and replica databases. For example, master users who define publications must have access rights to tables referenced by the publications. This also allows them to drop the publication.
▪ The master user of the system who requires rights to perform synchronization operations through the SYS_SYNC_ADMIN role created specifically for administrative tasks.
▪ The master or local users who require rights to register replica databases for synchronization through the SYS_SYNC_REGISTER_ROLE.