User Table

imco

Member
I'm looking for the file/table name that holds all USERIDs for version 8.10.

I need to query to get a list of all userids from the database.
 
In F0092 you can obtaing userid, but here you have role too. You can use this sql to get you user.

select uluser,ulan8
from SY812.F0092 a , SY812.F98OWSEC b
where a.uluser = b.scuser
and b.SCEUSER='01'
order by 1 , 2
 
Back
Top