This discussion is archived
6 Replies Latest reply: Sep 17, 2012 7:55 PM by Mark Malakanov (user11181920) RSS

Replicating only changes made by a specific database user

591783 Newbie
Currently Being Moderated
Hi,

I would like to perform replication for all the tables in the database. However, I would only like to replicate any DML changes done by certain database account.

Example, I have database account "appserveraccount", "batchjobaccount" in the database.

The web application hosted on the application server will be using "appserveraccount" for all the database operations.

The quartz scheduler will be connected to database using "batchjobaccount".

and I only want the changes from application server to be replicated from the primary database to the secondary database server.

Is that possible?

Edited by: liangtehz on Sep 14, 2012 11:33 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points