Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

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

You need to grant the execute privilege explicitely.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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