General Information
Library Note
Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx .
Purpose
Undocumented Support Package for DBMS_CRYPTO
AUTHID
DEFINER
Dependencies
Documented
No
First Available
12.2
Security Model
Owned by SYS with no privileges granted.
Source
{ORACLE_HOME}/rdbms/admin/prvtcia.plb
Subprograms
STATSDECRYPTNUM
Undocumented
dbms_crypto_internal.statsDecryptNum(
obj_nbr IN NUMBER,
col_nbr IN NUMBER,
encrypted_num IN NUMBER)
RETURN NUMBER;
DECLARE
objNum sys.wri$_optstat_histhead_history.obj#%TYPE := 8476;
intCol sys.wri$_optstat_histhead_history.intcol#%TYPE := 1;
encryptMinVal sys.wri$_optstat_histhead_history.minimum_enc := 2199;
BEGIN
dbms_crypto_internal.statsDecryptNum (obj#, intcol#, minimum_enc);
END;
/
STATSDECRYPTRAW
Undocumented
dbms_crypto_internal.statsDecryptRaw(
obj_nbr IN NUMBER,
col_nbr IN NUMBER,
ciphertext IN RAW)
RETURN RAW;
exec dbms_crypto_internal.statsDecryptRaw( obj#, intcol#, lowval);
STATSENCRYPTNUM
Undocumented
dbms_crypto_internal.statsEncryptNum(
obj_nbr IN NUMBER,
col_nbr IN NUMBER,
num_in_clear IN NUMBER)
RETURN RAW;
TBD
STATSENCRYPTRAW
Undocumented
dbms_crypto_internal.statsEncryptRaw(
obj_nbr IN NUMBER,
col_nbr IN NUMBER,
cleartext IN RAW)
RETURN RAW;
TBD
UPDATESENSITIVESTATS
Undocumented
dbms_crypto_internal.updateSensitiveStats;
exec dbms_crypto_internal.updateSensitiveStats ;
PL/SQL procedure successfully completed.