5

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?

7

This solved the issue for me:

grant execute on sys.dbms_crypto to myuser;

I had a similar problem with the random function.

4

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

You need to grant the execute privilege explicitely.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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