Re: Audit with triggers

From: Neil C <btsscrth_at_bt.com>
Date: Mon, 20 Sep 1999 15:58:18 +0100
Message-ID: <7s5i6d$h71$1@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 - 09:58:18 CDT