[CLOSED] Access to Secured Encrypted data

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/5097041196/m/9497065196

August 30, 2019, 12:57 PM

[CLOSED] Access to Secured Encrypted data

Does anyone have any experience accessing data in tables where the column has been encrypted like SSNs

This message has been edited. Last edited by: FP Mod Chuck,

August 30, 2019, 01:28 PM

FP Mod Chuck

Az

Are you really still using WebFOCUS 7.1.3? What database is the encrypted data stored in?

September 04, 2019, 12:32 PM

Sorry Chuck:
I did not see that. No we are about to move into 82. Any thoughts on my question?

Thanks

September 04, 2019, 12:36 PM

FP Mod Chuck

Az

I found an entry on the techsupport site that says Encryption, and decryption of the data is done by the Oracle Relational Database Manager, and will be transparent to WebFOCUS. If the data is displayed in readable format in native Oracle, it will display correctly in WebFOCUS.. I would assume that to be true of most other databases but don't have any experience.

I also found this entry as well that talks about using 3rd party tools to handle this. https://techsupport.informatio...track/170922042.html

This message has been edited. Last edited by: FP Mod Chuck,