AudienceView Connect
 Product Guides   Knowledge Base   Discussions   Support   Annual Conference   Developer Guide Login   Developer Guides  
 

Modifying Column Keys

Table of Contents | Previous | Next

Similar to modifying master keys, you can change the column keys (Encrypting a Column and Related Audit Columns) or remove the encryption, as needed.

Changing column’s keys requires you to enter the existing keys in the 'Old Master Keys' fields, as well as, provide the new keys. Otherwise the procedure is the same as the Add Key procedure.

The following steps describe how to change column keys:

  1. Once you have connected to your database (as outlined in Key Ring Tab), stop IIS.
  2. Select the Key Ring tab.
  3. Click 'Current Column Key: Entered'.
    A pop-up window will display:
  4. Enter and verify the 'Current Column' fields with what is currently entered for 'Column Keys 1'.
  5. Click 'OK'.
    A second pop-up window will display:
  6. Enter and verify the 'Current Column' fields with what is currently entered for 'Column Keys 2'.
  7. Click 'OK'.
  8. Click 'Column Keys: Blank'.
    A pop-up window will display:
  9. Enter and verify 'Column Key 1' fields.
    If encryption is currently not used, leave this area blank.
    The 'Component Key Check' field (available as of AudienceView 6.8.11) is only used when encrypting ID TECH payment devices.
  10. Click 'OK'.
    A second pop-up window will display:
  11. Enter and verify the 'Column Key 2' fields.
    The 'Component Key Check' field (available as of AudienceView 6.8.11) is only used when encrypting ID TECH payment devices.
  12. Click 'OK'.
  13. Select the column to encrypt with the new column key from the 'Column Name' dropdown list.
  14. Click 'Change Key'.