Loading into _user table

[bobben_1]

Wondering if someone can help. I'm running on Windows NT with version 8.3C.

Currently my application does not use any login to the database itself, but rather has its own user table that it does the verification against for the login.

I now want to set it up so that one of the 2 databases that we connect to accepts a user id and password as well, but without making the users enter the information twice. So basically I want to take a dump of the current user table and then put it in the correct format so i can load it into the databases _user table.

However when I do the load the problem appears to be that the password I have loaded in is not in an encrypted format.

Is there a quick way to load in _user information with a password so that it will work??

Thanks.

 

[leowie]

hi,
I think dump/load will not work.
maybe this way ...

FOR EACH OLD-DB._user EXCLUSIVE-LOCK:
FIND FIRST NEW-DB WHERE NEW-DB.profiles.user_password = OLD-DB._user._userid EXCLUSIVE-LOCK NO-ERROR .
F NOT AVAIL NEW-DB THEN MESSAGE "Create first ..." VIEW-AS ALERT-BOX.
ELSE DO:
IF OLD-DB._User._Password <> ENCODE("":U) THEN NEW-DB.profiles.user_password = OLD-DB._user._password.
END.
END.

 

[bobben_1]

Thanks...using the ENCODE function has allowed me to do what i need to do...thanks for the help