Online Documentation for SQL Manager for SQL server

Creating/editing symmetric key


Use the Symmetric key tab of Symmetric Key Editor to create/edit a symmetric key and specify its properties.

 

Name

Enter a name for the new symmetric key, or view the name of the symmetric key being edited.

 

Symmetric Key Editor - Editing symmetric key definition

 

 

Key options

 

Key source

Specify a passphrase that will be used to derive the key from.

 

Algorithm

Use the drop-down list to specify an algorithm to be used by the symmetric key. Possible values are: DES, TRIPLE_DES, RC2, RC4, DESX, AES_128, AES_192, AES_256.

 

Identity value

Specify an identity phrase from which to generate a GUID for tagging data that is encrypted with a temporary key.

 

Create date

Stores the date when the symmetric key was created.

 

Modify date

Stores the date when the symmetric key was last modified.

 

 

Symmetric key encrypt by

This area lists the encrypting mechanisms used by the symmetric key (the ENCRYPTION BY clause).

 

To add an encrypting mechanism, right-click within the Symmetric key encrypt by area and select the iconPlus Add Encryption popup menu item.

 

The Add Encryption By dialog allows you to specify a password, a certificate, an asymmetric key, or a symmetric key to be used to encrypt the key that is being created.

 

Symmetric Key Editor - Add encryption

 

 

To remove an encrypting mechanism, right-click the encrypting mechanism within the Symmetric key encrypt by area and select the iconMinus Drop Encryption popup menu item.