System Administration

Security Column Encryption

Use this page to Monitor Columns for Encryption.

To access this page, select Admin > Security > Security Management > Column Encryption in the Navigation pane.

NOTE: After a user clicks the View Data icon on the Security Column Encryption page, the report records display on a page that is also named Security Column Encryption. This page displays the column encryption data as it appears in the table.

Field

Description

DATA SOURCE

Displays the name of the data source where the column is encrypted.

TABLE NAME

Displays the name of the table that contains the column where the data is encrypted.

COLUMN NAME

Displays the column name within the TABLE NAME. This is the column that is either required or suggested for encryption.

KEY ID

Displays the name of the encryption key, as defined on the Encryption Keys page.

STATUS

Displays an icon to symbolize the encryption state of the column. Options are:

  • Green circle – Encryption is required (ENCRYPTION REQUIRED is checked) and encryption is enabled (ENCRYPTION STATE is “Encrypted”).
  • Yellow triangle – Encryption is not required (ENCRYPTION REQUIRED is not checked) and the column is not encrypted (ENCRYPTION STATE is “NotEncrypted”).
  • Red circle with slash – Encryption is required (ENCRYPTION REQUIRED is checked), but the column is not encrypted (ENCRYPTION STATE is “NotEncrypted”).

  • Warning icon - Encryption is in a mixed state for this column. Refer to Resolve Columns with Data in a Mixed State of Encryption for more information.

ENCRYPTION STATE

Displays the current state of the encrypted column. Options are:

  • Decrypting – the column is in the process of being decrypted
  • Encrypted – the column is encrypted
  • Encrypting – the column is in the process of being encrypted
  • NotEncrypted – the column is not encrypted

ENCRYPTION REQUIRED

If checked, encryption for the column is required. If the column is not encrypted, daily emails are sent to Security and Data Source Administrators, suggesting that the column should be encrypted.

If disabled, encryption for the column is not required.

When a new column is added for encryption (on the Data Source Column Encryption page), the ENCRYPTION REQUIRED check box is enabled by default. Disable encryption from the Data Source Column Encryption page.

SYSTEM PROVIDED

If checked, this content is installed with the Stewardship Tier and cannot be edited.

If unchecked, the content was added by a user or process.

NOTE: This is a display-only check box. It cannot be updated.

NOT ENCRYPTED COUNT

Displays the number of columns in the table that are not encrypted.

TOTAL COUNT

Displays the total number of columns in the table.

NOTE: If this value and the value in the NOT ENCRYPTED COUNT are not equal, data in the column is in a mixed state of encrypted and decrypted. Refer to Resolve Columns with Data in a Mixed State of Encryption for more information.

View Data

Click to view the column encryption data as it appears in the table.