Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

SQL_OPTION NO_CRYPT_SYSTBL

SQL_OPTION NO_CRYPT_SYSTBL

In V10.3 and later, FairCom DB SQL system tables are encrypted by default to protect sensitive database meta data. Any of the advanced encryption algorithms can be specified, so for example you can protect these tables using AES with a 128-bit key. When advanced encryption is not specified, data is hidden with the less-secure CAMO. (CAMO or "Camouflage" is an older, legacy method of hiding data, which is not a standards-conforming encryption scheme, such as AES. It is not intended as a replacement for Advanced Encryption or other security systems.)

To have system tables in clear text, SQL_OPTION NO_CRYPT_SYSTBL must be placed in ctsrvr.cfg before the database is created.

TOCIndex