Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-01031: insufficient privileges SYS.DBMS_LOCK

ORA-01031: insufficient privileges SYS.DBMS_LOCK

From: Rajani <rajania_at_yahoo.com>
Date: 21 Jan 2002 09:57:38 -0800
Message-ID: <ca0733.0201210957.3440150c@posting.google.com>


I'm trying to compile a stored procedure which was using a package called 'DBMS_LOCK'. It was giving error when I was compiling it. The error was " PLS-00201: identifier 'SYS.DBMS_LOCK' must be declared". So I found that I need to grant some EXECUTE privilege on DBMS_LOCK. I was running the following statement "GRANT EXECUTE ON SYS.DBMS_LOCK TO USER;" and it was throwing the error "ORA-01031: insufficient privileges".

What I'm doing wrong, in here? If any of you have any ideas please let me know.

Thanks,
Rajani. Received on Mon Jan 21 2002 - 11:57:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US