I'm using Oracle Database 11g Express Edition Release 126.96.36.199.0. My problem is I'm trying to grant permission to my schema using this script:
grant execute on DBMS_CRYPTO to my_user;
ERROR at line 1:
ORA-00942: table or view does not exist.
Please help. Thank you.
Edited by: user13831927 on Dec 13, 2012 12:09 PM
What user are you logged in as? I'm guessing that you are not connected as SYS-- you are probably connected as a user that does not himself have access to the DBMS_CRYPTO package. You'll need to connect as SYS.