Access

Click Features > Column Encryption to manage the data encryption of the database table columns.

Table of Contents

Overview

The Column Encryption functionality provides the possibility to encrypt the database column so that any data of this column can be encrypted and protected from the access without a special key.

Search

To search for a menu or filter the search results, use the following search filters and enter any or all the search criteria:

• Table Name

• Column Name

After filling in the filters, click the Enter key or any screen place. The screen displays search results if found. Please note, that letters or part of the word entered in the search filter fields will be taken into account while searching as well.

Sort Results

You can sort search results by the columns in ascending (arranged from the smallest to the largest number and alphabetically for letters) or descending (arranged from the largest to the smallest number and in reverse alphabetical order for letters) order. Columns' names, by which search results can be sorted, are indicated with arrows. Click the appropriate column name to sort search results by it.

Navigate

Use the navigation bar at the bottom of the Menu Overview page to navigate through the pages. Click the appropriate page number to open it. Use the Arrow icons to go to the next page of the previous page of the search results list accordingly. 

Click the Show All button to display all the results on one page.

Create Column Encryption

Click the Create button on the Overview page to create a Column Encryption. This opens the Create Column Encryption page. 

Specify the following data:

• Table Name - select the database table from the drop-down list.

• Column Name - select the table column that should be encrypted.

After filling in the fields click the Submit button to save the created entry. Click the Back button to go back to the Overview page without saving the data.

Update Column Encryption

To edit a Column Encryption, click the Edit (pencil) icon for the selected Column Encryption entry in the search results table. The Update Column Encryption page opens for editing.

After making the necessary changes, click the Submit button. To return to the Overview page, click the Back link. 

Delete Column Encryption

To delete a Column Encryption, click the Delete icon on the Overview page for the selected Column Encryption entry. The confirmation pop-up will appear where you can confirm or cancel the action.