patternModerate
Oracle 11g DBMS_CRYPTO invalid identifier
Viewed 0 times
oracle11gdbms_cryptoidentifierinvalid
Problem
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 ?
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 ?
Solution
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.
Here DBA has to login as SYS. Even SYSTEM or any other schema for that mater, which has SYSDBA role won't do.
Context
StackExchange Database Administrators Q#56658, answer score: 12
Revisions (0)
No revisions yet.