Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CREATE OR REPLACE -- insufficient privilegies

382358Jan 6 2006 — edited Jan 9 2006
Hello,
I get ORA-01031: insufficient privileges when trying to CREATE OR REPLACE a package body.
I can drop it and create it again, but not just replace it. It is very annoying when using a GUI for developing PL/SQL code.
This works fine on 8i and 9i. I have not tested it with 10g.
Thanks for your help.

C:\>sqlplus system/manager@xe @priv

SQL*Plus: Release 10.2.0.1.0 - Beta on Fri Jan 6 10:38:03 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

SQL>
SQL> DROP USER myuser CASCADE
2 /

User dropped.

SQL> CREATE USER MYUSER IDENTIFIED BY MYUSER
2 /

User created.

SQL> GRANT CREATE SESSION TO MYUSER
2 /

Grant succeeded.

SQL> GRANT CREATE ANY PROCEDURE TO MYUSER
2 /

Grant succeeded.

SQL> GRANT DROP ANY PROCEDURE TO MYUSER
2 /

Grant succeeded.

SQL> GRANT UNLIMITED TABLESPACE TO MYUSER
2 /

Grant succeeded.

SQL>
SQL> DISCONNECT
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta
SQL>
SQL> CONNECT MYUSER/MYUSER@XE
Connected.
SQL>
SQL> CREATE PACKAGE mypackage AS
2 PROCEDURE myproc;
3 END;
4 /

Package created.

SQL>
SQL> CREATE PACKAGE BODY mypackage AS
2 PROCEDURE myproc
3 IS
4 BEGIN
5 NULL;
6 END;
7 END;
8 /

Package body created.

SQL>
SQL> CREATE OR REPLACE PACKAGE BODY mypackage AS
2 PROCEDURE myproc
3 IS
4 BEGIN
5 NULL;
6 END;
7 END;
8 /
CREATE OR REPLACE PACKAGE BODY mypackage AS
*
ERROR at line 1:
ORA-01031: insufficient privileges


SQL>
SQL> DROP PACKAGE BODY mypackage
2 /

Package body dropped.

SQL>
SQL> CREATE OR REPLACE PACKAGE BODY mypackage AS
2 PROCEDURE myproc
3 IS
4 BEGIN
5 NULL;
6 END;
7 END;
8 /

Package body created.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2006
Added on Jan 6 2006
7 comments
1,169 views