Re: Audit with triggers

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:24:15 CDT