Database Encryption for Increased Security

Overview

Since AGRIS (version 9.5.0.5), you have the ability to enable Pervasive PSQL ZEN database encryption, which helps protect you and your customers from threats such as identity theft or corporate espionage.

Database file encryption prevents users from viewing and/or changing the data in a database file. Administrators can specify the level of encryption as either:

Any number of individual files in a package
All the files in an individual package
All the files in all packages

These options give you great flexibility in specifying which files to encrypt.

Unsecured Database File

Encrypted Database File

Procedure

From the AGRIS Main menu, click on Maintenance → File Maintenance to display the File Maintenance Option Selection dialog box.
Either highlight 8) Encrypt/Decrypt Files, or type 8 in the Option field.
Click on:

Button	Description
Back	to close the File Maintenance Option Selection dialog box.
Select	to display the Select Package dialog box.

4. For each package file you want to encrypt or decrypt:

a. Highlight the package by clicking on it once.

b. Click on:

Button	Description
Back	to return to the File Maintenance Option Selection dialog box.
Select	to open the Package Files dialog box for that package.

TIP:

If you want to encrypt or decrypt all the files in all the packages, select the ALL option.

The Encrypt/Decrypt All Packages dialog box appears, asking you to select whether you want to encrypt all the files, or decrypt them.

The Encrypt/Decrypt All Files Dialog Box

Highlight the option you want to use, then click on the button to execute that option. Once the packages are all encrypted/decrypted, the Select Package dialog box appears.

The Package Files Dialog Box

c. Highlight the file you want to encrypt or decrypt by clicking on it once.

TIP:

If you want to encrypt or decrypt all the files in this package, select the ALL <PKG NAME> option. The Encrypt/Decrypt All Files dialog box appears, asking you to select whether you want to encrypt all the files, or decrypt them.

The Encrypt/Decrypt All Files Dialog Box

Highlight the option you want to use, then click on the button Select to execute that option. Once the files are all encrypted/decrypted, the dialog box appears, identifying all encrypted files with an X.

d. Click on:

Back to return to the Package Files dialog box without changing the encryption status of the selected file.

Select to encrypt or decrypt the selected file. An alert box appears, asking you to confirm that all users are logged out of the selected database.

The Log Out All Users Alert Box

Click on:

Back to return to the Package Files dialog box without changing the encryption status of the selected file.

Select to encrypt or decrypt the selected file. During the encryption/decryption process, a message appears at the bottom of the dialog box.

The Encrypting/Decrypting File Message

When the encryption/decryption process is complete, the Package Files dialog box appears identifying, with an X, those files that are encrypted.

The Package Files Dialog Box

5. When you are finished encrypting or decrypting files in this package, click on the Back button to return to the Select Package dialog box.

6. When you are finished encrypting or decrypting package files, click on the Back button to return to the File Maintenance Option Selection dialog box.

7. Click on the Back button to close the File Maintenance Option Selection dialog box.