imco Member Jul 18, 2012 #1 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.
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.
XaviGray Active Member Jul 19, 2012 #3 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
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