3.6.1 Ensure a strong system encryption password is set

Information

It is the responsibility of the System Security Officer to set a strong system encryption
password. This password is used to generate a 128-bit key-encrypting key, which in turn is
used to encrypt column encryption keys (created by users with the create encryption
key privilege).

Rationale:

Setting a weak system encryption password facilitates the decryption of column encryption
keys and ultimately the data itself.

Solution

1. Connect to the ASE server as a user with the sso_role and execute the following
SQL statement to set a system encryption password (where <Password> should be
substituted for the strong system encryption password). Note that support for
encrypted columns must be enabled before the system encryption password can be
set.

exec sp_encryption system_encr_passwd, '<Password>'

See Also

https://workbench.cisecurity.org/files/1612