• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Command to execute usergrpdef to add user

 4 Replies
 1 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Roger French
Veteran Member Send Private Message
Posts: 549
Veteran Member
7/18/2017 5:11 PM

Has anyone have a LID command to automatically add a new user to a user group, using usergrpdef. I have the user, group (existing), but I want to run it in a command, and not have to run usergrpdef manually and the subscreens to add the user to the group, etc.

Thanks in advance.

Edited: 

This is V10 so LAUA is not possible. 

Also I am trying to avoid manually populating the required GEN Tables.

 

 

Kwane McNeal
Veteran Member Send Private Message
Posts: 479
Veteran Member
7/18/2017 5:21 PM
Two ways I know of:
1) Pass a keystroke stream to usergrpdef
2) load the data directly into GEN
...I have never done it using method #1, but I have done something similar with laua, and know it's possible.

Unless you have some odd requirement for using usergrpdef, I'd use method #2
Deleted User
New Member Send Private Message
Posts: 0
New Member
7/18/2017 5:30 PM
Hi, I've done it using method #2 described above. Here's the shell script code that I use that does even more than you're asking:
echo "Adding Lawson environment data..."
# Next, we'll add usergrpdef needed values
sqlplus -s gen/$mGen < set echo off
set feedback off
UPDATE gen.userinfo
set usergrp='LSFALL', jobqgrp='LSFALL'
where username='$mAIXID';
UPDATE gen.r_user
set printergroup='LSFALL'
where username='$mAIXID';
INSERT INTO gen.usergrpdtl
(USERGRP, USERNAME, R_TYPE)
VALUES
('LSFALL','$mAIXID','55');
exit
EOF11

(you can see that I'm using variables for the gen pword along with the user)
Let me know if you have questions.
Kwane McNeal
Veteran Member Send Private Message
Posts: 479
Veteran Member
7/18/2017 5:36 PM
Another would be to write temp files, and use importdb.
This is the tool I use if it's in a script.

Leonard's script also looks good, just remember to update the literal values.
Roger French
Veteran Member Send Private Message
Posts: 549
Veteran Member
7/18/2017 7:06 PM

But the thing with the SQL INSERT, for new records (adding a new record) into R_USER, because the columns are all NOT_NULL type (SQL DB, LSFV10.0.9), you have to have all the values in R_USER populated using SQL INSERT. I don't want to populate all of the columns in R_USER because for this install, the values aren't needed.

I'll just use importdb instead.