On what table(s) can I find these various user profiles kept?

I've grabbed the WEBUSER table to have a list of RD30 records, and the REQUESTOR table for a list of RQ04 records, but haven't located the table that stores the application (lid) users and their security class, or those who have been granted FTP or DB access...any ideas?

My purpose is to link these in a report (maybe crystal, but probably access), and be able to pull a list of all users at any given time, showing what aspects of the system they have access to.

Thanks!

You'll find users and their security classes listed in the GEN/USERS table, but you'll have to use rngdbdump to extract the info in csv format to load into Access (or whatever..)

Lawson doesn't control ftp access - and your DB access is controlled by your database system. You'll have to get that info from your system admin and DBA respectively.

Ah, thanks for the insight.

We're a Siemens remote client, so I simply use an environment form to grant/deny DB and FTP access...but yeah, it makes sense that those are not controlled from within Lawson.