Dear Appeon Team,
We are using MS SQL Application role in our Power Builder Desktop application, and the SP sp_setapprole called through power builder code by passing Role name and Password.
We have an security issue here as the password is hard-coded in the power builder code to enable Application Role for currently logged-in user. As per security standards, the passwords should NOT be hard-coded or stored in config/INI files or SQL tables. We would like to know the best way to secure the password in Power Builder application.
Thank you,
Suresh
Can you please let me know which encryption algorithm (ex: SHA1, MD5 or ???, etc..) is more secure for encryption and description for protecting the password. As you suggested, we are trying to see if this can be implemented in Power Builder code.
Also, would you mind providing sample code for for encryption and decryption, or reference link for the same?
Appreciate your help in this regard !!!.
Thank you,
Suresh
Note that I'm not an encryption expert. I believe Roland has a free example of encryption and decryption on his TOPWIZ website.
https://www.topwizprogramming.com/freecode.html