Re: Who's the procedure owner?

How about:
select userenv('schemaid') from dual?

"Luis Cabral" <luiscabral_at_starmedia.com> wrote in message news:8o65dr$t2e$1_at_nnrp1.deja.com...
> Hello
>
> Say user1 has a procedure called proc1 in the database.
> Say user2 has the very same procedure, also called proc1.
> Say user3 is executing the procedure proc1. By the way,
> user3 can be accessing user1.proc1 or user2.proc1,
> depending on how the synonyms are defined, ok?
>
> Inside proc1, how can I know on which schema the
> procedure is running (user1 or user2)? If I use the
> "user" function, I will get "user3" (the connected
> user).
>
> Thank you
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Aug 27 2000 - 15:53:15 CDT