View Full Version: Gen User Table Import

LawsonTalk > Security > Gen User Table Import



Title: Gen User Table Import


area51 - July 14, 2008 05:47 PM (GMT)
OS: Solaris
Env: 8.0.3.7
Apps: 8.0.3


So for the past few days I've been trying to get a new test system up and running as we have a consultant starting tomorrow on getting us to LSF9. I've taken a lot of shortcuts but they only thing I'm stuck at right now is assigning security classes to users. We have a lot of both. I changed the name of the Productline otherwise I would just copy the GEN table.

I know GSC doesn't support dumping and importing into the USER table, but has anyone had any problems doing this?

schroncd - July 15, 2008 10:50 PM (GMT)
I don't think you need to go that far.

Clone GEN to your new env, then:
secdump old_pline dumpfile
secload dumpfile new_pline

With any luck your USERS table will get updated when the security classes are updated.

g'luck!!

area51 - July 16, 2008 02:52 PM (GMT)
I got that portion alright. The problem is that it doesn't attach the security classes to the people. That's why I was thinking of dumping the USER table and loading it using importdb, but it says there are 'binary fields' in the table so it scared me off.




Hosted for free by InvisionFree