APEX

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 PL/SQL package execute permission to a user, but which user?

M.EmmanuelAug 13 2016 — edited Aug 15 2016

I want to grant permission to DBMS_CRYPT as I am using it during a form field computation. User enters its password and this is hashed via a custom package which calls DBMS_CRYPT.

Custom package has been granted to PUBLIC.

I am getting error ORA-04063 while using that function, and I did not have anything to grant execute permission for package DBMS_CRYPTO.

To which user should I grant access?

Is that something to be done at database level or can it be accomplomished through APEX directly?

Thanks,

This post has been answered by Scott Wesley on Aug 14 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 12 2016

Added on Aug 13 2016

#apex-discussions

7 comments

2,970 views