|
|
|
c-treeACE SQL system tables are now encrypted by default to protect sensitive database meta data. The encryption algorithm is AES with a 128-bit key when advanced encryption is in use (meaning ADVANCED_ENCRYPTION is active in ctsrvr.cfg). When not using the advanced encryption, this data is scrambled with 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.
