Re: Logs

If you would like to prevent him from modifying it (which for me implies you don't trust that employee) he should get a shell of any sort and not be able to get into svrmgr. Which basically means he has his hands tied on his back and can't do anything when real disaster occurs.
Also, if you really want to 'capture all changes' you have to implement the trigger solution, and you will create a tremendous amount of data (not information) you simply are not going to look into (or until months after 'something' occurred). Speaking from experience of course!

Best regards,

--
Sybrand Bakker, Oracle DBA
<veenad_at_my-deja.com> wrote in message news:826naq$skk$1_at_nnrp1.deja.com...
> 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 - 16:36:12 CST