Re: Dynamic Sql Problem

From: Rolf Hauck <Rolf.Hauck_at_datenrevision.de>
Date: Thu, 03 Sep 1998 11:54:53 +0200
Message-ID: <35EE676D.2344A5C4@datenrevision.de>

Hi,
for a procedure to work properly, the necessary rights have to be granted directly to you, not to a role you have.

Rolf

Param wrote:
>
> Hi,
>
> I have to write a small Stored Procedure which will drop and create a
> sequence.
>
> But I am facing a problem. This same SP works fine if the statement is a
> 'DROP' but
> for a 'CREATE'.
>
> I am getting error 1031 - Insufficient Privileges for a create
> statement.
> I am able to CREATE and DROP everything from the SQL Prompt.
>
> I have also tried executing the very same code as a PL/SQL Block and it
> works.
Received on Thu Sep 03 1998 - 04:54:53 CDT