PL/SQL priviledges

From: <ctneil_at_nettaxi.com>
Date: Wed, 15 Dec 1999 14:32:32 GMT
Message-ID: <8388q0$1jd$1@nnrp1.deja.com>

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)

Help?
(I am using oracle 7)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 15 1999 - 08:32:32 CST