F98OWSEC - Enable user

Hello. Our company is a new user of JDE OneWorld/Xe AS/400. We already have a situation. We would like to write a program that will re-enable a disabled user. We know the file is F98OWSEC. The field does not seem to be visible. I am sure this question has been asked many times--is there a way to re-enable a user this way?? Thanks for all your help!

A Newbie!

Why wouldn't you just use the P98OWSEC to do this? Bring up the user that is disabled, highlight the username and hit the "Revise Security" row exit. This will bring up a screen where you can change the user status.

We understand how to do it from WITHIN JDE; we need to have a way to do it OUTSIDE the normal process.

Thanx!

The enable/disable field is called SCEUSER, and is in the F98OWSEC table. A value of "01" indicates enabled, while "02" indicates disabled.

So a fairly simple SQL update would be:

UPDATE SYS7333.F98OWSEC SET SCEUSER='01' WHERE SCUSER='username';

Hope this helps.

F98OWSEC.SCEUSER is the column.

"01" = Enabled
"02" = Disabled.

Never tried to directly adjust this value, so, you should run a log against the P98OWSEC function when it makes this change. This will show if anything else is changed when status is changed by the application..

There is a column in F98OWSEC called SCEUSER when it's set to a value of 01 the ID is enabled 02 it's disabled. A simple SQL update command could enable the account e.g. UPDATE SYS7333/F98OWSEC set SCEUSER="01" where SCUSER="USERNAME"...

You didn't mention where you wanted to run this from a client PC or the AS/400 Ent Server.
From a client PC with Client Access Express you would want to create an ODBC data source and use that to connect with Access, VB or whatever.
On the AS/400 a simple CL program could do this as well.

Thanx to all! Will give the suggestions a try....

Why not use the OneWorld security program to re-enable
there UserID? Menu GH9052 > User Security > Find your
user > Highlight there ID > Click revise security exit

--- rklopfer <[email protected]> wrote:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=50807


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/