Audit values

alter

alter table

3

Keywords or options:

• ADD/DROP/MODIFY COLUMNS

• REPLACE COLUMN

• ADD CONSTRAINT

• DROP CONSTRAINT

If 1 or more encrypted columns are added, keywords will contain:

ADD/DROP/MODIFY COLUMNS column1/keyname1, [,column2/keyname2]

where keyname is the fully qualified name of the key.

create

create table

10

For encrypted columns, keywords contain column names and keynames.

EK column1/keyname1[,column2 keyname2]

where EK is a prefix indicating that subsequent information refers to encryption keys and keyname is the fully qualified name of the key.

encryption_key

sp_encryption

106

Keywords contain ENCR_ADMIN system_encr_passwd password ******** if password is set the first time, and contains ENCR_ADMIN system_encr_passwd password ******** ******** if the password is subsequently changed

create encryption key

107

Keywords contain:

algorithm Name-bitlength/IV [RANDOM|NULL]/PAD [RANDOM|NULL]

For example: AES-128/IV RANDOM/PAD NULL

alter encryption key

108

Keywords contain:

NOT DEFAULT

if key no longer the default key.

DEFAULT 

if the key is made the default key

drop encryption key

109