Oracle Database 12c Security Cookbook

Setting master encryption key in software keystore

In this recipe, you're going to create the first master key for the password-based software keystore you created and opened in the previous recipe.

Getting ready

It is assumed that software keystore is already opened. To complete this recipe, you'll need an existing user who has the SYSKM administrative or administer key management privilege (for example, maja).

How to do it...

1. Connect to the database as a user who has the SYSKM administrative or administer key management privilege (for example, maja):

   $ sqlplus maja
   

2. Create a master key for the password-based keystore (Figure 7 shows the creation of master key for the keystore you created in the recipe Creating and opening the keystore):

   SQL> ADMINISTER ...