Replication Agent for Oracle uses the pds_username to connect to Oracle and must have the following Oracle permissions:
create session – required to connect to Oracle.
select_catalog_role – required to select from the DBA_* views.
alter system – required to perform redo log archive operations.
execute on DBMS_FLASHBACK – required to execute DBMS_FLASHBACK.get_system_change_number.
alter any procedure – required to instrument procedures for replication.
create table – required to create tables in the primary database.
create procedure – required to create rs_marker and rs_dump proc procedures.
create public synonym – required to create synonyms for created tables in the primary database.
drop public synonym – required to drop created synonyms.
select on SYS.OBJ$ – required to process procedure DDL commands.
select on SYS.LOB$ – required to support LOB replication.
select on SYS.COLLECTION$ – required to support table replication.
select on SYS.COL$ – required to support table replication.
In addition, the user who starts the Replication Agent for Oracle instance must have read access to the Oracle redo logs.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
