Enabling EUA and Performing Encryption on an Existing Database

From InterBase

Go Up to Encrypting a Database with IBConsole


To enable EUA and perform encryption on an existing database, take the following steps:

  1. Connect to the database you want to encrypt as the owner.
  2. In the left pane, right-click on the database name and select Properties from the context menu or select Database > Properties from the menu.
  3. In the Database Properties dialog, click on the General tab.
    EncryptEnable.png
  4. Select the Embedded User Authentication checkbox. Notice that the dialog now shows three new options.
    • Select the EUA Active checkbox, a new setting will be available below.
    • Select the Database Encrypted checkbox.
    • You do not need to change the Default Password Digest setting.
  5. Click OK to enable EUA. The dialog closes and the Encryption Wizard opens.
    Encryption wizard, initial page
  6. After reading the page, click Next.
  7. In in the SYSDSO Information screen, enter a Password and click Next.
    Step 1: Enter the SYSDSO password
  8. In the SEP screen, create and confirm a System Encryption Password. Then click Next.
    Note:
    For more information about External, see Using the External Option when Creating a SEP.
    Step 2: Create the SEP
  9. In the Encryption Information screen, click Create New Encryption.
    Step 3: Select an encryption key
    • In the new Encryption Editor dialog, you can specify a name for the encryption key and set other parameters.
      Step 3-1: Create an encryption key
    • The encryption key used to encrypt a backup needs to be password protected. You can create a key without a password, but that will cause problems if that key is used at the time of backup.
    • It is recommended that you select the Default Key check box. However, it is not required.
    • Click Ok to save your settings and close the dialog.
    • The Encryption Key has been created, click Next to continue.
      Step 4-2: Create an encryption key
  10. In the Backup/Restore Key screen click Create Backup Encryption.
    Step 4: Select an encryption key
    • In the new dialog, enter a name for your key and a password, click Ok to save your settings.
      Step 4-1: Create an encryption key
    • The Backup Key has been created, click Finish to save your settings.
      Step 4-2: Create an encryption key
    The dialog closes and a message opens informing you that the encryption of database is complete.
Note:
For more information about Embedded User Authentication, see the InterBase Operations Guide.

Advance To: