Re: PL/SQL priviledges

A copy of this was sent to ctneil_at_nettaxi.com (if that email address didn't require changing) On Wed, 15 Dec 1999 14:32:32 GMT, you wrote:

>According to the books, the priviledges needed for the functions
>are required of the user who compiled them (user1) and not of the user
>now executing them (user2).
>
>but...
>
>I have created all objects as user1 with DBA role and given them public
>synonyms.
>I then granted execute on two PL/SQL functions to user2's role.
>One of these functions creates users and works fine.
>The other is meant to drop users but I am told that I have insufficient
>priviledges. (ORA-01031)
>

the owner of the procedure (user1) does not have the privelege to DROP users *when roles are not enabled*. roles are not enabled during procedure compilation/execution.

see http://osi.oracle.com/~tkyte/Misc/RolesAndProcedures.html for more info

>Help?
>(I am using oracle 7)
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
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 Wed Dec 15 1999 - 08:54:24 CST