Re: Username in PL/SQL
From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 26 Aug 1999 10:08:28 +0200
Message-ID: <7q2sn2$a25$1_at_oceanite.cybercable.fr>
Date: Thu, 26 Aug 1999 10:08:28 +0200
Message-ID: <7q2sn2$a25$1_at_oceanite.cybercable.fr>
You can get the user calling the function with the key word USER in a select statement:
create function my_function...
is
calling_user varchar2(30);
...
begin
select USER into calling_user from dual;
...
end;
/
Edward Beemer a écrit dans le message <7q2pr6$ibs$1_at_zonnetje.nl.uu.net>...
>Hello guys,
>
>How can I use the username of the currently logged on user in a PL/SQL
>function?
>
>I would like to call some function with the current username as a parameter.
>
>With kind regards,
>Edward Beemer
>
>
Received on Thu Aug 26 1999 - 10:08:28 CEST