Skip to Main Content

Java Development Tools

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!

ORA 1031 error Insufficient privileges

Dino2dyMay 7 2010 — edited Nov 17 2010
Hello All

I have a problem finishing a tutorial on jdeveloper, the one on databases. I am almost at the end and have a DB connection called FOD i then executed this sql code:

connect system/(my password);

grant debug connect session to fod;

That went well. After that I was supposed to execute this sql code:

REM
REM Create object ORDER_ITEMS_REC
REM

CREATE or REPLACE type ORDER_ITEMS_REC as object
(
ORDER_ID NUMBER(15),
LINE_ITEM_ID NUMBER(3),
PRODUCT_ID NUMBER(15),
QUANTITY NUMBER(6),
UNIT_PRICE NUMBER(8,2),
CREATED_BY VARCHAR2(60),
CREATION_DATE DATE,
LAST_UPDATED_BY VARCHAR2(60),
LAST_UPDATE_DATE DATE,
OBJECT_VERSION_ID NUMBER(15)
);
/
show errors;

This however gave me this error:

ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to change the current username or password
without the appropriate privilege. This error also occurs if
attempting to install a database without the necessary operating
system privileges.
When Trusted Oracle is configure in DBMS MAC, this error may occur
if the user was granted the necessary privilege at a higher label
than the current login.
*Action: Ask the database administrator to perform the operation or grant
the required privileges.
For Trusted Oracle users getting this error although granted the
the appropriate privilege at a higher label, ask the database
administrator to regrant the privilege at the appropriate label.
No Errors.


I know this is a common problem but I did search through some threads for example these two

http://kr.forums.oracle.com/forums/thread.jspa?messageID=2468640

http://kr.forums.oracle.com/forums/thread.jspa?messageID=4224432

Unfortunately due to my lack of understanding or just simple stupidity I was unable to solve the problem.

Any help would be appreciated
This post has been answered by Paul (MITsa) on May 7 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2010
Added on May 7 2010
13 comments
8,045 views