14 Replies Latest reply: Feb 1, 2011 7:15 AM by 176301 RSS

    grant  on sys.dbms_crypto to public

    707291
      I am on 11g version.
      Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
      connecting as user with dba privileges and granting.

      GRANT EXECUTE ON "SYS"."DBMS_CRYPTO" TO "PUBLIC";
      ============
      ORA-00942: table or view does not exist ?


      I dont want to run this connecting as /sysdba but normal dba user. Is there any way ?

      I could able to do this on another database which is of version
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production ?

      Edited by: Phani_Orcl on Dec 23, 2010 11:32 PM