General Information
Library Note
Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com . Request a Workshop for
your organization today.
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.