Select user into :host_variable from dual;
Folks, correct me if I am wrong.
What about SYS_CONTEXT?
Regards,
Allen
-----Original Message-----
From: Шатыр Дан Юрьевич [mailto:oracledba-ezmlmshield-x39723031.[Email address protected]
Sent: Wednesday, September 05, 2007 4:33 PM
To: LazyDBA Discussion
Subject: Current login
Hello
Please point me the way to find out which is the current user name in my PL/SQL procedure. ( I mean, who calls my procedure)
Thanks for your help,
Dan.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
www.wipro.com
Oracle LazyDBA home page