select a.username, b.* from v$session a, v$access b
where a.sid=b.sid;
"Шатыр Дан Юрьевич "
<oracledba-ezmlmshield-x39723031.[Email address protected] wrote on
09/05/2007 07:02:36 AM:
> 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
>
>
---
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
Oracle LazyDBA home page