Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » User and database security » Data security » Database encryption and decryption » Column and table encryption


Enabling table encryption in a database (dbinit utility)

You can enable table encryption during the creation of a database, using the command line.


Table encryption must be enabled and configured at database creation time. You must re-create the database with table encryption enabled if your database does not have table encryption enabled, or if you have database encryption in effect.

  • Create a database with the dbinit -et and -ek options, and specify a key and an encryption algorithm.


Table encryption is enabled.


The following command creates the database new.db with strong encryption enabled for tables using the key abc and the AES256_FIPS encryption algorithm, and sets the DBA user ID to DBA with password sql:

dbinit -dba DBA,sql new.db -et -ek abc -ea AES256_FIPS

Later, when you encrypt a table in this database, the AES256_FIPS algorithm and abc key are used.