Password Encryption

[Terry B]

Hi All

We currently store sensitive information in a table, and would like to make it difficult to understand this information when viewing a table directly (UTB, SQL etc).

Any suggestions?

Maybe if someone has an encryption algorithm I could "borrow". I'd understand if you don't want to make it public, and I would be discrete.

Thanks,
Terry

 

[mpatel]

Take a look at blowfish, a freely available encryption and decryption algorithm -- http://www.schneier.com/blowfish.html

Manoj Patel

 

[Alex_Pastuhov]

There's no way [that I can see] to develop this once and plug it into the JDE infrastructure, so you will need to implement it yourself in all programs that write these fields and all programs that read these fields.

You may adopt some simple code, when [de-]obfuscating the text, like replacing letters with different ones, accordingly to a pre-defined substitution table, i.e.: "e" for an "r", etc. - like what JDE did to obfuscate the user passwords before SP21...

 

[Terry B]

[ QUOTE ]
Take a look at blowfish, a freely available encryption and decryption algorithm -- http://www.schneier.com/blowfish.html

Manoj Patel

[/ QUOTE ]

Hi Manoj

Thanks for the info.

Regards,
Terry