How Do I Encrypt Data Inside a Table? (Magic xpa 4.x)
Even when you use passwords and restrict access, it is possible, using low-level tools, to view data directly from a disk. For this reason it is necessary to encrypt tables that contain very sensitive information.
Magic xpa makes this very easy. Just follow the steps below.
-
In the Data repository, go to the table you want to encrypt.
-
Go to Data Source Properties (Alt+Enter, or Edit->Properties).
-
For the Access key, enter any string of characters. It is recommended though, that you use a Secret Name (How Do I Hide Database Login Information?).
-
Set Encrypt table to Yes.
Now, the data in the table will be encrypted. Only someone who has the same key can view the data.
Note: Not all DBMSs support encrypted data. If underlying the DBMS does not support this form of encryption, then the Access Key and Encrypt table fields will be greyed out.