HiveBrain v1.2.0
Get Started
← Back to all entries
patternModerate

Oracle 11g DBMS_CRYPTO invalid identifier

Submitted by: @import:stackexchange-dba··
0
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 ?

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.

Context

StackExchange Database Administrators Q#56658, answer score: 12

Revisions (0)

No revisions yet.