CREATE OR REPLACE -- insufficient privilegies
382358Jan 6 2006 — edited Jan 9 2006Hello,
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.