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 KEY MANAGEMENT SET KEY IDENTIFIED BY
          keystore_password
   	   WITH BACKUP
   	   USING 'desc_purpose';
   

   

   Figure 7

There's more...

The WITH BACKUP clause in step 2 instructs Oracle Database to create a backup of a keystore before the creation...