Re: Audit
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: Barbara Baker <barb.baker@xxxxxxxxx>
- Date: Thu, 29 Sep 2005 14:04:28 -0400
Thank you Barbara,
I have just set up the audit delete any table, but didn put by access with
that.
Let me do that and I will let you know if required more help for the same.
Thanx
- Chirag
On 9/29/05, Barbara Baker <barb.baker@xxxxxxxxx> wrote:
>
> 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:
