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.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|