Re: Audit with triggers

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:08:41 CDT