helpkey – lists encryption key properties, including:
Whether the database contains encryption keys.
The following, when run by a user with sso_role, key custodian, or DBO: keyname, keyowner, key length, key algorithm, key type, pad, initialization vector, type of password used to encrypt the key, whether key recovery has been enabled and count of key copies. The output is sorted on owner.keyname. When run by a non-privileged user, this command will list keyname, keyowner and keytype.
help – included for backward compatibility. Includes the same output as helpkey.
key_name – name of the key you are investigating. Lists the properties defined for key_name. If key_name is omitted, lists properties for all keys.
wildcard – lists the properties for keys matching the wildcard pattern in the current database.
all_dbs – lists information on encryption keys in all available databases. Only the SSO can run all_dbs.
key_copy – lists all user copies for the specified key in the current database. The output is sorted by key_owner.key_name. Includes information about:
The base key owner.
If the key copy is a recovery key copy.
The user to whom a copy belongs.
If the copy is encrypted with a user-encryption password, a login password, or the system encryption password for login association (indicated by Login Access).
display_cols – displays the key name, all keys (or matching wildcard keys) in the current database and the columns the key encrypts. When SSO includes display_cols, it displays columns encrypted by the keys across all available databases. When a user without the sso_role runs display_cols, only those columns encrypted by the key in the current database are displayed. Data is sorted by key_name, key_owner, database_name, table_owner, table_name, and column_name.
helpcol column_name– displays the column name and the key used to encrypt the column. If the SSO includes helpcol, it prints the key name even if the key is not present in the current database. If a non-SSO user includes helpcol, Adaptive Server prints the keyid of the key if it is not present in the current database, omitting the key_name. The output includes: owner.table.column, database.owner.keyname. The information is sorted by owner.table.column.
helpuser – displays the keys owned by or assigned to a user in the current database.
system_encr_passwd – displays the keys and key copies that are encrypted using the system encryption password in the current database.
display_keys – used with system_encr_passwd to display the keys and key copies that are encrypted using the system encryption password.
