Re: Which user owns a procedure call?

I always assumed it ran as the user who created the procedure unless you specify otherwise.

You can specify in a certain version of Oracle, not sure which version it is though. I know it is included in 8.1.6

M

thanhh.nguyen_at_amd.com (Thanh) wrote in message news:<82cc18be.0205061334.56b36cc_at_posting.google.com>...
> In the different versions of Oracle, I seem to recall that in one
> version, if a user calls a procedure owned by a different user, the
> procedure is executed with the procedure owner's privileges, and in
> another version, it runs with the calling user's privileges. Is this
> really the case, and which version does which? Thanks.
>
> thanh
Received on Tue May 07 2002 - 10:04:24 CEST