Oracle | DBMS_INTERNAL

Oracle DBMS_INTERNAL_CLKM Version 21c

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 (Updated to 12.2.0.1)

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

GET_KEY_FOR_OBJ

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