Name

USER_KEY_STORE — Saves a key in the database and in case the database is restarted, the key will be loaded again.

Synopsis

USER_KEY_STORE ( in username varchar ,
  in key_name varchar ,
  in key_type varchar ,
  in key_format varchar ,
  in key_pwd varchar ,
  in key_value varchar := NULL );
 

Description

This function saves a key in the database and in case the database is restarted, the key will be loaded again.

Parameters

username

User name

key_name

Key name

key_type

Key type

key_format

Key format

key_pwd

Key password

key_value

Key value

Examples

Example 24.436. Persisting a key & certificate

The example below persists a key named 'id_rsa' and certificate created for it into user's key space. Thus after server restart the key will be available again.

SQL> USER_KEY_STORE (user, 'id_rsa', 'X.509', 2, '', xenc_pkcs12_export ('id_rsa', 'CA Certificate', ''));