Re: ddl using dynamic sql problem

Hi Adam,

all the rights you need for the execution of you SP must be directly granted to you (e.g. the one who executes SP). Right granted to roles will be ignored.

Adam Dickman schrieb:
>
> I have built a database procedure that reorganize objects by concatenating
> the extents of objects that have more than 5 extents into 1 extent. To do
> this I have used dbms_sql dynamic sql procedures and functions.
>
> The problem that I have encountered is that when I try and enable a primary
> key constraint using this method I get an oracle error indicating
> insufficient privileges.
>
> If you have encountered this problem or any thing similar please contact me.
> I have even tried granting dba to this user.
>
> Regards
> Adam Dickman

--

Regards

Matthias Gresz :-)

GreMa_at_t-online.de Received on Fri Apr 24 1998 - 07:01:25 CDT