5 Replies Latest reply: Jul 22, 2008 11:23 AM by ski123 RSS

    grant execute on DBMS_LOCK to PUBLIC;

    ski123
      Oracle 10g, I try to this:

      grant execute on DBMS_LOCK to SMITH;

      I got an error: ora-01031: insufficient privilige

      I am a DBA and have DBA access. I even login as system user, still give me this error.

      Any ideas?
      Please help.
      S.