Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamic SQL puzzle
Freda,
You're right, the problem is with privileges. Most likely you got the
execute privilege on DBMS_SQL through a role and not directly. Remember
that privileges granted through roles do not apply in Procedures.
hope that helps
Venkat
>ORA-01031: insufficient privileges
>ORA-06512: at "SYS.DBMS_SYS_SQL", line 239
>ORA-06512: at "SYS.DBMS_SQL", line 32
>ORA-06512: at "ITS.TEST1", line 8
>ORA-06512: at line 1
>
>Strangly the code for Test1 works fine on one test machine but not
>another so I suspect the privileges aren't set correctly.
>Basicly Test1 drops, creates, and grants permissions for a sequence.
>What's going on?
Received on Wed Mar 04 1998 - 00:00:00 CST