meerasatya
23rd June 2008, 20:50
I have gone through the post and still couldn't find answer to my problem.

We are on ERP LN6.1 on windows server and database is SQL.

I have a field on client and I masked it with inputfiled.password. I Want the same field to be masked(******) even at GTM level. If any one logs in to GTM they should be able to see the field as*******. And when authorized person logs in client level, system should let him to enter value by comparing user input and table value.

I saw threads using crypt.password$(), but looks like its not available in LN 6.1.

Can anyone help me with this.

Thanks
Meer

NPRao
23rd June 2008, 21:44
I saw threads using crypt.password$(), but looks like its not available in LN 6.1.
Meer,

What makes you believe it is not available in LN 6.1?

Refer to the posting - Encrypt/decrypt Password (http://www.baanboard.com/baanboard/showthread.php?t=26592&highlight=password)

I found it is being used in the source code of bc, dm and tg scripts.

meerasatya
23rd June 2008, 21:54
I couldn't find crypt.password$() in ERP LN help file. So I thought it's not available.

NPRao
23rd June 2008, 22:04
It is classified as - Undocumented Functions & Variables (http://www.baanboard.com/baanboard/showthread.php?t=36550)

meerasatya
27th June 2008, 03:02
Using crypt.password$(pwd1) i crypted the password and stored it in table.

When the user will be promted for pwd1 next time, when he enters the value, how can u validate both the values?

crypt.password$ will crypt the password and when user enter pwd1, it would be a string? How can you compare these two values ?

I tried to crypt.password pwd1 upon user entry, is.password.ok() is not validating both and returning false.

george7a
27th June 2008, 09:31
The last thread that NPRao mention (Undocumented Functions & Variables (http://www.baanboard.com/baanboard/showthread.php?t=36550)) contains useful links with examples. Here they are
http://www.baanboard.com/baanboard/showthread.php?t=10166
http://www.baanboard.com/baanboard/showthread.php?t=26579&highlight=is.password.ok
http://www.baanboard.com/baanboard/showthread.php?t=28143&highlight=is.password.ok

I hope it helps,

- George

meerasatya
27th June 2008, 20:06
Using crypt.password$() I am storing the password in a table.

When user print a report next time, he will be poped up for password, there he has to enter the password that was saved.

I didn't see any help/function to encrypt the password, so when I call is.password.ok() , its always false.
because table filed has crypted value and user will enter normal password- so its returning false
even when I crypt user password and compare with table value - its false again as bothe the crypted strings are not equal.
can anyone have any idea

NPRao
28th June 2008, 00:01
When user print a report next time, he will be poped up for password, there he has to enter the password that was saved.
You have to implement with Role based security for the Session than using password way.
The example program is simple and obvious. You have to check your code and re-evaluate your requirement and implementation approach.

meerasatya
28th June 2008, 00:59
Thank you for your reply.