Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

grant on sys.dbms_crypto to public

707291Dec 24 2010 — edited Feb 1 2011
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
This post has been answered by Syed_Ibrahim on Dec 24 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2011
Added on Dec 24 2010
14 comments
26,336 views