slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: How to encrypt password fields in DB Tables ?

CGK
Posts: 34

How to encrypt password fields in DB Tables ? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Sep 07 1:08 AM

Hi all!

My requirement is:
1. There is a grid in my application and that has a password field retrieved from the database to be displayed. I need to display asterisks (*****) instead of the string there. How can I do this ?

2. How to encrypt the password fields in the database tables, so that even an DBA willnot be able to know the password ?

Any suggestions/pointers would be of good help!

TIA!
CGK.

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: How to encrypt password fields in DB Tables ? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Sep 07 1:14 AM

While it's certainly not the most secure encryption, SLX does have a DLL that you could use for basic encryption. See more about it here: http://customerfx.com/pages/crmdeveloper/2004/02/10/39095.aspx

[Reply][Quote]

Swapnil
Posts: 46

Re: How to encrypt password fields in DB Tables ? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Sep 07 12:47 AM

Hi Chaitanya,
You can use SLXRWEL.dll for encrypt & decrypt password.
Hers is the sample code:
Set objRwel = CreateObject("SLXRWEL.SLXRWEOBJ")
' To encrypt
sEncrypted = objRwel.Add(password)
' to decrypt
sDecrypted = objRwel.Remove(password)
Set objRwel = Nothing

[Reply][Quote]

CGK
Posts: 34

Re: How to encrypt password fields in DB Tables ? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Sep 07 1:40 AM

Thanks Ryan and Swapnil. It helped

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 8:22:06 PM