Re: Which user executes my procedure?

Klim Samgin <klimsamgin_at_yahoo.com> skrev i artiklen <880js9$rqb$1_at_nnrp1.deja.com>...
> Hi, All!
>
> I've got PL/SQL procedure and I granted execute on it
> to some db users.
>
> Can my procedure to find out which user execute it?
> This may help to configure procedure behaviour for each user.

Select user into :executing_user from dual;

Peter Laursen Received on Fri Feb 11 2000 - 03:28:33 CST