Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Baselines and Java Internals
On Tue, 2004-07-20 at 16:06, John Kanagaraj wrote:
> I am inclined to think of a Statspack type of architecture where you
> 'snapshot' DBA_OBJECTS to be used for comparison. The drawback is that you
> might miss multiple changes in between. However, if you can capture all DDL
> events into a persistent table (as I am doing), then you could produce both
> a Periodic report as well as programmatically provide snapshots of
> changes....
>
John,
Yes, I have thought of the change history aspect. Even if you run a new snapshot every minute, you will still miss changes.
Even though changes will be missed, an auditor should be able to reconstruct the events leading up to final change by examining the change control history.
If the results are different, then unauthorized changes likely took place.
Jared
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Jul 21 2004 - 10:20:56 CDT
![]() |
![]() |