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>'