Re: Logs

Roy,
  But Can the DBA change these settings ?   Our intent is to capture all the changes done to the database including that of the DBA, and prevent the DBA from modifying them.   Any help would be greatly appreciated.

Regards,
Veena

In article <82656c$e2u$1_at_nnrp1.deja.com>,   rspeaker_at_my-deja.com wrote:
> You can turn auditing on at the access level, and that would give you
> information regarding changes such as inserts, updates, deletes, along
> with who made the change and when. I don't believe it will give you
the
> ability to see the 'before' and 'after' image, however. I think you
> will probably have to use a trigger of some sort if you want to
capture
> that information. Probably a before trigger, and you can capture the
> NEW. and OLD. values and log them to a table.
>
> HTH,
> Roy
>
> In article <824hi5$a4f$1_at_nnrp1.deja.com>,
> veenad_at_my-deja.com wrote:
> > Hello,
> > In Oracle can we log the actions of the DBA. We just want to
> determine
> > if we can find out in any way what the DBA has modified or deleted
in
> a
> > record.
> >
> > Please do advise me if I can achive this kind of security at all in
> > Oracle.
> >
> > Thanks and Best Regards
> > Veena
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 02 1999 - 15:12:30 CST