Oracle DBMS_INTERNAL_CLKM
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 This package, not installed by default during database creation supports Transparent Data Encryption according to the GoldenGate docs. Certainly the "KM" in the name does point to "Key Management"
AUTHID DEFINER
Dependencies (Updated to 12.2.0.1)
DBMS_INTERNAL_CLKM_LIB    
Documented No
First Available 12cR1
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/prvtclkm.plb
Subprograms
 
GET_KEY
Undocumented dbms_internal_clkm.get_key(
client        IN  VARCHAR2,
master_key_id IN  VARCHAR2,
wrapped_key   IN  VARCHAR2,
flags         IN  BINARY_INTEGER,
key           OUT VARCHAR2);
--  if GoldenGate is installed and the database utilizes TDE cd to the $GG_HOME directory, run the prvtclkm.plb script, and grant EXECUTE to the GoldenGate user.

Enter user-name: / as sysdba

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> desc DBMS_INTERNAL_CLKM
ERROR:
ORA-04043: object DBMS_INTERNAL_CLKM does not exist


SQL> @?/rdbms/admin/prvtclkm.plb

SP2-0808: Package created with compilation warnings

Library created.

SP2-0810: Package Body created with compilation warnings

SQL> GRANT execute ON dbms_internal_clkm TO ggadmin;

Grant succeeded.
 
GET_KEY_FOR_OBJ (new 12.2)
Undocumented dbms_internal_clkm.get_key_for_obj(
client      IN  VARCHAR2,
objno       IN  BINARY_INTEGER,
key_val     OUT VARCHAR2,
key_val_len OUT BINARY_INTEGER,
enc_alg     OUT BINARY_INTEGER,
int_alg     OUT BINARY_INTEGER);
TBD

Related Topics
DBMS_GOLDENGATE_AUTH
GoldenGate
Packages
Security
Transparent Data Encryption
Wallet
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