Column Encryption Keys Properties

Properties of column encryption keys and key copies.

Click the Name field of the column encryption key, then click the drop-down arrow and select Properties.

Pages Properties
  • 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, the datatype padding is used 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 – the general properties of key copies, including database, owner, assignee, and type of password.
  • Key-copy management:
    • Create a new key copy.
    • Delete a key copy.
Object Permissions
  • Grantees and other object information – list the grantees and grantee types for the key, and information whether select is granted.
  • Permissions – modify permissions to users, groups, or roles.
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