ORA 1031 error Insufficient privileges
Dino2dyMay 7 2010 — edited Nov 17 2010Hello 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