You need to be the object owner (in this case SYS) in order to perform grants.
rajania_at_yahoo.com (Rajani) wrote in message news:<ca0733.0201210957.3440150c_at_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 - 22:25:06 CST
