User Security data after upgrade from 8.9 to 8.12..

Any help with this will be greatly appreciated..

We have begun the 8.9 to 8.12 upgrade. All of the User Ids came across no problem, however, the User Security data (Password, System User, etc.) did not come across. I would hate to have to manually enter password and system user information for all of the users. Is there a UBE I can try to run again to get this data to move?

Also, is there any easy way to populate the environments to the roles? Right now, I have to go into each role and add DV812 and JDV812 to each of them. Any ideas?

Thanks,
Matthew

Hi,

We had the same troubles with an upgrade from B8.9
to E8.12; System users did pass from B8.9 to E8.12,
however JDE users didn't.

Denver confirmed us that it was an "expected inconvenient behaviour". A kind of cynical euphemism that may be
translated as "it's a bug we know about, but we don't
care to fix it, so it's up to you to retype them all".

So, at the end, we had to retype the password for every
user (about 200).

On the other hand, the environment x role issue can
be easily fixed via a lovely SQL command.

Let's suppose you want to add DV812 and JDV812 to
all of your DV9 users :

INSERT INTO SY812.F0093 SELECT LLUSER, 'DV812' AS LLLL,
401 AS LLSEQ, '' AS LLMNI FROM SY812.F0093 WHERE LLLL='DV9'
AND LLUSER IN (SELECT LLUSER FROM SY812.F0092 WHERE
ULUGRP = '*GROUP')

INSERT INTO SY812.F0093 SELECT LLUSER, 'JDV812' AS LLLL,
402 AS LLSEQ, '' AS LLMNI FROM SY812.F0093 WHERE LLLL='DV9'
AND LLUSER IN (SELECT LLUSER FROM SY812.F0092 WHERE
ULUGRP = '*GROUP')

Luis Santillo wrote a beautiful tool which can help you reset passwords "en masse."

This is a Java utility, and instructions to build and compile are located here:

http://www.jdelist.com/w3tfiles/111951-JXMLSec.doc