Re: Trigger Question

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