| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: execute privileges error
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
 |
 |