3. Planning Your Replication Scheme : How You Prepare for Replication : Database Administrator Privileges : Define the ingrep Role
 
Share this page                  
Define the ingrep Role
If the DBAs of the source and target databases are different, before a Replicator Server is started, the ingrep role must be created in the iidbdb database of every installation that has a database participating in the replication scheme and that contains a full peer or protected read-only CDDS. For more information on creating a role, see the SQL Reference Guide.
Installations running Ingres must also grant the ingrep role to the DBA by executing a GRANT statement in the iidbdb, as follows:
grant ingrep to public
or
grant ingrep to user replicator_dba
where:
replicator_dba
Is the database administrator for Replicator.