the SQL statement is: SELECT * from Table(Users()) x;
http://archive.midrange.com/midrange-l/201301/msg00528.html

I tried this UDFT User Defined Table Function. It was great at
returning a list of User-Profiles and the User's names.
But as I suspected, this generated messages in security logs.
What showed up in security logs were CPI2246 errors, in the format of .
. .

1/14/13 10:15 AF CPI2246 User PROGRAMMER not authorized to object
QSYS/USER1 type *USRPRF.

So I will go back to using the Profile Swapping APIs of QSYRUSRI to read
current user profile and QWTSETP to reset the user profile when I have
to list all user-profiles.




Return to Archive home page | Return to MIDRANGE.COM home page