patternModerate
Granting privileges to dbms_crypto
Viewed 0 times
privilegesdbms_cryptogranting
Problem
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?
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?
Solution
This solved the issue for me:
I had a similar problem with the random function.
grant execute on sys.dbms_crypto to myuser;I had a similar problem with the random function.
Code Snippets
grant execute on sys.dbms_crypto to myuser;Context
StackExchange Database Administrators Q#40026, answer score: 11
Revisions (0)
No revisions yet.