Re: Database comparisons
From: GovindanK <gkatteri_at_fastmail.fm>
Date: Mon, 11 Jan 2010 23:43:25 UT
Message-Id: <1263253405.8105.1354131709_at_webmail.messagingengine.com>
> The auditor's question was essentially that "you are making
changes to table A and verifying those changes, but how do you know the application didn't also change table B".
Date: Mon, 11 Jan 2010 23:43:25 UT
Message-Id: <1263253405.8105.1354131709_at_webmail.messagingengine.com>
> The auditor's question was essentially that "you are making
changes to table A and verifying those changes, but how do you know the application didn't also change table B".
If that be the concern, then the following should help
audit_trail= db / db,extended
audit alter table on <user> , audit create table on <user>
Query dba_audit_object
HTH GovindanK
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 11 2010 - 17:43:25 CST