Sybase Replication Agent requires that all user IDs that create transactions that will be replicated must have select authority on the following Oracle dynamic performance views:
V_$SESSION
V_$TRANSACTION
To set up select authority for the Replication Agent, you must log in as the SYS user (or a user with SYSDBA ROLE) and execute the following SQL commands:
grant select on V_$SESSION to public grant select on V_$TRANSACTION to public
