Re: ORA-01031: insufficient privileges SYS.DBMS_LOCK

You must grant this with a DBA account such as SYS or SYSTEM.

You can not grant yourself privileges.

Daniel Morgan

Rajani wrote:

> 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 - 06:09:18 CST