Re: Which user owns a procedure call?

ThanH,

hopefully you will get this - my work has just gone behind a ne firewall and NNTP (News) is no longer permitted, so I have to read and post from Google until further notice :o(

A PL/SQL procedure/function etc is owned by the user who created it. When called from any other user (which has been given EXECUTE privs on the proc) it runs as if called by the owner.

However, from 8i onwards (not sure which exact version of 8i) the proc can be created with AUTHID CURRENT USER tagged on to the end of the CREATE xxxx statement. In this case, any user executing the proc executes it as themeselves and not as the owner.

HTH Regards,
Norman.

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 - 12:33:42 CEST