Re: Audit with triggers

WONDERFFFUUULLLLL I ow you one

Cheers

Neil C <btsscrth_at_bt.com> wrote in article <7s5jn1$htj$1_at_pheidippides.axion.bt.co.uk>...
> Well, i dont know if is the nicest way but you could try :-
>
> SELECT osuser FROM v$session
> WHERE schema# = (SELECT userenv('schemaid') from dual);
>
> Cheers
>
> NeilC
>
>
> Frederic DEBRUS wrote in message <01bf037b$162a60c0$3e35a99e_at_gal159a>...
> >ok but
> >
> > user fred is making a insert on table test
> >
> > trigger after insert on test do a insert on manipulation table
> >
> > recording
> > who 'fred' select osuser from v$session
> > (but this will report ALL users connected how to select the current
> >user only)
> > mades_what 'insert' hardcoded
> > table 'test' hardcoded
> > value_before :old.aaaa hardcoded
> > value_after :new.aaaa hardcoded
> >
> >Many thanks
> >
> >Neil C <btsscrth_at_bt.com> wrote in article
> ><7s5i6d$h71$1_at_pheidippides.axion.bt.co.uk>...
> >> Hi,
> >>
> >> yes you can use select osuser from v$session, of course, depending on
the
> >> user running / owning the triggers, you may have to grant select on
> >> v_$session table.
> >>
> >> HTH
> >>
> >> NeilC
> >>
> >> Frederic DEBRUS wrote in message

<01bf0377$384b1720$3e35a99e_at_gal159a>...
> >> >Hi there,
> >> >
> >> > I'm trying to make some audit using triggers,
> >> >populating a "manipulation table" recording who made what with
> >> >the values of the column before and after it's working fine but I
would
> >> >like
> >> >to kwown the osuser and record it. How can I access this information
> >from
> >> >my trigger (select osuser from sys.v_$session where ?????)
> >> >
> >> >thanks
> >>
> >>
> >>
>
>
>
Received on Mon Sep 20 1999 - 10:21:31 CDT