Re: execute privileges error
Date: 1996/12/18
Message-ID: <32b75f1b.7101070_at_dcsun4>#1/1
On Tue, 17 Dec 1996 21:19:26 +0100, Finn =?iso-8859-1?Q?Elleb=E6k?= Nielsen <ellebuk_at_vip.cybercity.dk> wrote:
>Thomas J. Kyte wrote:
>>
>> The user system gets it's ability to drop users via the DBA role. Since roles
>> are never enabled when a stored procedure executes, SYSTEM doesn't have the
>> ability to drop the user. You need to grant drop user to system first.
>>
>> On 16 Dec 1996 22:27:56 GMT, lesliet_at_u.washington.edu (L. Tseng) wrote:
>>
>> >I created the following procedure under SYSTEM
>> >but keep getting the following error
>> >
>> >ERROR at line 1:
>> >ORA-01031: insufficient privileges
>> >ORA-06512: at "SYS.DBMS_SYS_SQL", line 239
>> >ORA-06512: at "SYS.DBMS_SQL", line 25
>> >ORA-06512: at "SYSTEM.TEST_DBMSSQL", line 7
>> >ORA-06512: at line 1
>> >
[snip]
>
>I don't think it's a case about privileges on the drop, but privileges on doing
>dynamic DDL as the following case illustrates:
>
Let me clarify a little:
Since roles are never enabled when a stored procedure execute, SYSTEM doesn't have the ability to drop the user *FROM A STORED PROCEDURE*. You need to grant drop user to system first.
>- The user has DBA rights.
>- Can create other users and drop them directly, but not from dynamic DDL.
>- What's wrong here?
>
[snip]
>
>Cheers,
>
>Finn Ellebaek
>
>--
>--------------------------------------------------------------------------------
> Finn Ellebaek Nielsen Oracle Associated Senior Consultant
> E-mail: ellebuk_at_vip.cybercity.dk Ellebaek Consulting
> Mob. Phone: +45 20 32 49 25 Niels Ebbesens Vej 9, 3. th.
> Mob. Phone SMS: 20324925_at_sms.tdm.dk DK-1911 Frederiksberg C
> Private Phone: +45 33 25 34 50 Denmark
>--------------------------------------------------------------------------------
> "Life is a beach and then you dive" "Divers do it deeper"
Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com
- Check out Oracle Governments web site! -----
Follow the link to "Tech Center"
and then downloadable Utilities for some free software...
statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Wed Dec 18 1996 - 00:00:00 CET