Database Encryption Keys Properties

Properties of database encryption keys.

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

Pages Properties
General
  • Name – change the name of the encryption key.
  • Type – indicates that this is a database encryption key.
  • Database – indicates what database the encryption key is for. The default is master, since the database encryption key is created only in the master database.
  • Owner – you can change the owner of the encryption key if you have change permission.
  • Creation date – shows when the encryption key was created.
  • ID – shows the ID number of the encryption key.
  • Key length (bits) – shows the key length, in bits. The only valid value is 256.
  • Key algorithm – shows the algorithm. For database encryption keys, the only valid value is AES.
  • Initialization vector – shows the initialization vector for the database encryption key. The only valid value is "random."
  • Encrypted by – indicates that the database encryption key was created by the master key. If you used a dual-master key, to create the database encryption key with dual control selected, you can change the setting if you have change permission.
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 databases – list the databases encrypted by this key.