Re: Priviliges for SQL running inside a Procedure

A copy of this was sent to "Daniel Reis" <dreis_at_capgemini.fr> (if that email address didn't require changing) On Mon, 29 Nov 1999 14:43:25 -0000, you wrote:

>SQL running inside a stored procedure runs with the permissions granted to
>the procedures owner.
>Is there a way to change this so that it runs with the caller's permissions
>
>TIA
>
>Daniel Reis
>

In Oracle8i, release 8.1, yes -- you can define a procedure with "authid current_user" which means that SQL and dynamic PLSQL calls are executed with the current privelege set (inclusive of roles) of the currently logged in user.

Prior to that -- no.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Nov 29 1999 - 08:59:58 CST