View History for Customer-Managed Encryption Keys on Autonomous AI Database

You can view the key history from the Oracle Cloud Infrastructure Console or by selecting from the V$ENCRYPTION_KEYS view.

To view the key history from the Oracle Cloud Infrastructure Console:

  1. On the Autonomous AI Database Details page, select the Key History tab.

  2. This shows the Key History.

    For example:

Description of adb_key_history.png follows

Description of the illustration adb_key_history.png

To view the key history by selecting from the V$ENCRYPTION_KEYS view:

  1. Connect to the Autonomous AI Database as the ADMIN user.

  2. As the ADMIN user, issue the following command:

     <pre class="language-sql copy"><code>SELECT activation_time, tag FROM V$ENCRYPTION_KEYS;</code></pre>

 For example:


 <pre class="language-sql copy"><code>SELECT activation_time, tag FROM V$ENCRYPTION_KEYS; ACTIVATION_TIME                TAG  ------------------------       ------------------------ 2020-02-19T17:21:57.821Z       {&quot;credential_name&quot;:&quot;OCI$RESOURCE_PRINCIPAL&quot;,                                 &quot;oci_management_url&quot;:&quot;https://aqm-management.kms.ca-toronto-1.oraclecloud.com/20180608/keys/&quot;,                                 &quot;master_key_id&quot;:&quot;ocid1.key.oc1.ca-toronto-1&quot;,&quot;username&quot;:&quot;&quot;ADMIN&quot;&quot;,                                 &quot;vault_id&quot;:&quot;ocid1.vault.oc1.ca-toronto-1&quot;}</code></pre>

See Notes for Using Customer-Managed Keys with Autonomous AI Database for more information.