Re: Trigger Question

From: Kurt Laugesen <KurtL_at_corebit.dk>
Date: Tue, 14 Sep 1999 11:00:56 +0200
Message-ID: <7rl30f$i2c$1@news.inet.tele.dk>

Michael Milliron <~okana_at_msn.com> wrote in message news:CrcD3.3440$R_.19333810_at_news5.usenetserver.com...
> This may be a stupid question:
>
> In using triggers - I am doing an insert into a separate table based on an
> update or insert into a table. Is there a way to get the Oracle user ID
of
> the person performing the update from within the trigger to use in the
> insert statment?
>
>
> Michael Milliron
> mikem_at_msamail.com
> okana_at_msn.com

Very simple - just refer to 'user' as in:

insert into <separateTable> (username,some_other_fields) values

                                          (user, some_other_values);

--
Regards
Kurt Laugesen
KurtL_at_corebit.dk
+45 40 90 49 30 Received on Tue Sep 14 1999 - 04:00:56 CDT