Re: Auditing...

From: Phil Hoggins <philh_at_sequent.com>
Date: 21 Apr 1998 12:52:14 GMT
Message-ID: <01bd6d22$e83142a0$f175549e@w-philh>

You can achive this by having triggers on the table in question. Triggers will allow you to manage user access on tables by logging the actions to another table. You can record before and after views of the data that is subject to an update and much more.

Phil

Jimmy <c6635500_at_comp.polyu.edu.hk> wrote in article <353D4FAE.72F0_at_comp.polyu.edu.hk>...
> Hello all,
>
> Is it possible to record who access table A in Oracle server? The
> access include select, update, delete and insert. I know that Oracle
> server can do audit in table level. Is it possible to audit in record
> level? i.e. to record which record in table A has been accessed?
>
> Thanks,
> Jimmy
>
Received on Tue Apr 21 1998 - 07:52:14 CDT