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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l