Re: Permissions problem using DBMS_SQL Package

Hi bevets !

When you run PL/SQL role are desactivated ! Grant the appropriate privilege to the user belonging the procedure (or package) executing your dynamic SQL!
For your problem, GRANT CREATE TABLE TO your_user !

Regards

bevets <bevets_at_mylaptop.com> a écrit dans le message : 7udik3$fca$1_at_uranium.btinternet.com...
> Can anyone help please???
>
> I've compiled my own package procedure CREATE_COPY_TABLE containing a call
> to DBMS_SQL.PARSE. The statement being parsed is CREATE TABLE fred AS
> SELECT * FROM joe - i.e. making a copy of table joe.
> I've then written a second, anonymous block which calls my procedure, and
> run it from the same userid that created the procedure, but when I run it
I
> get:
>
> ORA-01031: insufficient privileges
>
> Everything is using the same userID and I can execute the exact same
'ceate
> table' statement directly from SQL*Plus without problems, so why doesn't
it
> work as part of the procedure?
> Can anyone explain this mystery to me please and how I can solve it?
> Thanks.
> (PS. It's Personal Oracle 8.0.4 on Windows 98. The user ID has Connect,
> Resource and DBA privileges.)
>
>
Received on Mon Oct 18 1999 - 12:49:25 CDT