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.

Prerequisites

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.

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

Results

Table encryption is enabled.

Example

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.