Column Encryption Keys Properties

Properties of column encryption keys and key copies.

Click Properties on your column encryption key to initiate the Column Encryption Key Properties wizard to modify these properties:
Wizard Option Encryption Properties
General
  • Name – change the name of the encryption key.
  • Change Owner – change the owner of the encryption key.
  • Default – select this key as the default key to allow users to create encrypted columns without specifying the key.
  • Key recovery – indicates if this key has a recovery copy.
  • Init vector – use the initialization vector padding to increase the security of encrypted data by increasing the cryptographic variance of the cipher text.
  • Pad – if pad is set to random, Adaptive Server uses datatype padding when the length is less than one block.
Key Copies
  • Assignees and other information about keys – list the types of passwords and assignees for the key, and information about whether the key is recoverable.
  • Assignees and other information about key copies – click the Type of password field for your key copy, and select Properties to see the general properties of key copies, including database, owner, assignee, and type of password.
  • Key-copy management –
    • Create a new key copy by clicking on New. See Creating Key Copies.
    • Delete a key copy by clicking on the Type of password field for your key copy, and selecting Delete.
Object Permissions
Dependencies
  • Encrypted columns – list the columns encrypted by this key, and their databases and tables.
Related tasks
Creating a Column Encryption Key
Modifying and Deleting a Column Encryption Key
Executing SQL Statements
Modifying, Regenerating, and Deleting a Master Key