Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01031: insufficient privileges SYS.DBMS_LOCK
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
![]() |
![]() |