Oracle Audit and Oracle Replication

From: Lyndon Tiu <ltiu_at_alumni.sfu.ca>
Date: Wed, 29 Aug 2007 10:47:09 -0700
Message-Id: <200708291747.l7THl9H2005144@rm-rstar.sfu.ca>

Hi guys,

Replicated database group. Auditing enabled on all member databases in the replication group.

On all databases, the following command was run:

audit update table by access;

Then on one database, an update was done on a record in a regular table.

I see this update event recorded in sys.aud$.

But on the other members of the replication group. I do not see any update event recorded in the sys.aud$ table. Even though the record I updated got replicated across the wire.

Am I missing something?

How do I set it up so that replicated actions are also recorded in sys.aud$ Is this even possible?

Thanks.

--

Lyndon Tiu
--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 29 2007 - 12:47:09 CDT