Kbase P19405: Is there a way to encrypt data in a table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/02/2010 |
|
Status: Verified
GOAL:
Is it possible to encrypt data in an OpenEdge database.
GOAL:
Is there a way to encrypt data in a table?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
Depending on the release in use, several options are available to encrypt and decrypt the data stored in an OpenEdge database.
In releases earlier than OpenEdge 10.0B, data security is limited to the use of the ENCODE function, which provides a one-way hash encoding. As this is not reversible, it does not cover all possible encryption needs.
Starting with OpenEdge 10.0B, native support is implemented for symmetric encryption as part of the 4GL, allowing sensitive data to be encrypted before being written into a record, and to be decrypted when the record is read back from the database.
However, there still is no methodology at the database level that provides transparent encryption of all data in the database itself.
OpenEdge 10.2B introduces the Transparent Data Encryption as a core service, which allows sensitive areas or tables to be encrypted without having to change application code.
In addition to the above features, or as a replacement (for the releases where the feature is not available), consider using OS-level utilities, encrypted filesystems and/or hardware encryption.