Oracle DBMS_TDE_TOOLKIT
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Utilities supporting Transparent Data Entryption usage with DataPump
AUTHID DEFINER
Dependencies
DBMS_STANDARD KUPM$MCP KUPW$WORKER
DBMS_TDE_TOOLKIT_FFI KUPP$PROC UTL_RAW
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtdtde.plb
Subprograms
 
DATAPUMP_DECRYPT
Decrypts strings for DataPump dbms_tde_toolkit.datapump_encrypt(
instring  IN  VARCHAR2,
outstring OUT VARCHAR2,
keyid     IN  VARCHAR2);
As encryption can only be performed for a DataPump process decryption similarly includes a process check.
 
DATAPUMP_ENCRYPT
Encrypts strings for DataPump dbms_tde_toolkit.datapump_decrypt(
instring  IN  VARCHAR2,
outstring OUT VARCHAR2,
keyid     OUT VARCHAR2);
conn / as sysdba

set serveroutput on

DECLARE
 TestStr VARCHAR(4000) := 'Dan Morgan';
 RetKey  VARCHAR2(32);
 RetStr  VARCHAR2(4000);
BEGIN
  dbms_tde_toolkit.datapump_encrypt(TestStr, RetStr, RetKey);
  dbms_output.put_line(RetStr);
  dbms_output.put_line(RetKey);
END;
/

-- it detects that this is not a DataPump process
DECLARE
*
ERROR at line 1:
ORA-20109: Non-datapump process calling datapump_encrypt
ORA-06512: at "SYS.DBMS_TDE_TOOLKIT", line 19
ORA-06512: at line 6

Related Topics
Built-in Functions
Built-in Packages
DataPump
DBMS_CRYPTO
DBMS_DATAPUMP
DBMS_TDE_TOOLKIT_FFI
Security
Transparent Data Encryption
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved