Re: Audit

Guess I'm not sure what your question is.
but when you see 'session rec', that means you are auditing BY SESSION. In
this case, the column SES_ACTIONS is your friend.

When you audit by access, you get a record for each auditable action.
When you audit by session, you get 1 audit record for the entire session.
by access is easier to deal with, but takes more space in the aud$ table.

Show us how your auditing is set up, and maybe we can provide more help.
Barb


On 9/29/05, Chirag DBA <chiragdba@xxxxxxxxx> wrote:
>
> Hi ,
>  I am trying to do auditing on the DB for the first time.
>  I want to find couple of things but no luck.
>  Column STATEMENT on AUD$, didn give me the meaningful value, where can I
> find the table for all the listings.
> I am finding the meaningful values in DBA_AUDIT_TRAIL view.
>  When I do AUDIT DELETE ANY TABLE BY SCOTT; and deleting records from the
> table,
> I am getting values as follows.
> SCOTT SESSION REC 29.09.2005 11:42:24 0 TEMP 208
>  But I wanna see that deletion occured , I mean anything like ROWS DELETED
> or like that, possible?
> Cause if I enable insert,update,delete all three, how will be I
> differentiate this value SESSION REC?
>  Regards - Chirag
>

Other related posts: