Replication Server enforces security using the following features:
Replication Server login names
Each Replication Server has its own set of login names, which are distinct from data server login names. This distinction gives the replication system administrator control over replicated data and other aspects of the replication system.
Data server login names
Data server login names are used with client applications to connect to data servers. Clients are generally given permission to update primary data. On replicate tables, however, clients are generally granted permission to select or view data, but are prohibited from making changes to data. These permissions are controlled in the data server, according to the application.
Data server maintenance user login names
Replication Server uses a special data server maintenance user login name for each local data server database that contains replicate tables. This allows Replication Server to maintain and update the replicate tables in the database.
Password encryption
You can encrypt passwords in sensitive areas of the replication system.
Permission system
Replication Server permissions are assigned to and cancelled from Replication Server login names using the grant and revoke commands.
See “Replication Server roles and responsibilities” for more information about Replication Server and data server login names and roles.