8

I'm trying to grant proper privileges for using DBMS_CRYPTO.

Whenever I call it from package it gives me error: PLS-00201: identifier 'DBMS_CRYPTO' must be declared

User already has privileges: SELECT_CATALOG_ROLE EXECUTE_CATALOG_ROLE SELECT ANY DICTIONARY

and EXECUTE on DBMS_CRYPTO to package_owner.

any ideas what am i doing wrong?

2 Answers 2

5

Privileges obtained through a role are not in effect inside a stored procedure.

You need to grant the execute privilege explicitely.

11

This solved the issue for me:

grant execute on sys.dbms_crypto to myuser;

I had a similar problem with the random function.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.