Oracle DBMS_INTERNAL_CLKM
Version 23c

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 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
DBMS_INTERNAL_CLKM_LIB    
Documented No
First Available 12.1
Package Installation SQL> @?/rdbms/admin/prvtclkm.plb

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

SP2-0808: Package created with compilation warnings

Library created.

SP2-0810: Package Body created with compilation warnings

SQL> sho err
Errors for PACKAGE BODY DBMS_INTERNAL_CLKM:

LINE/COL ERROR
-------- -----------------------------------------------------------------
8/13 PLW-06010: keyword "KEY" used as a defined name
8/13 PLW-07203: parameter 'KEY' may benefit from use of the NOCOPY compiler hint
36/13 PLW-07203: parameter 'KEY_VAL' may benefit from use of the NOCOPY compiler hint
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
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
Built-in Functions
Built-in Packages
Security
DBMS_GOLDENGATE_AUTH
GoldenGate
Transparent Data Encryption
Wallet
What's New In 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx