Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Logs
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.
Received on Thu Dec 02 1999 - 10:02:44 CST