I'm trying to encrypt a column and I found many tutorials that use DBMS_CRYPTO.
However, when I test this, it says DBMS_CRYPTO is an invalid identifier.
I was using SYSDBA account.
I've searched the Internet but, to my surprise, I couldn't find an answer for this one.
How come DBMS_CRYPTO is an invalid identifier ?
Best Answer
DBMS_CRYPTO is a package which is owned by SYS schema. You can ask the DBA to give the execute privilege on that package to the schema which you are using.
Here DBA has to login as SYS. Even SYSTEM or any other schema for that mater, which has SYSDBA role won't do.