Welcome Guest [Log In] [Register]
Bookmark and Share
Welcome to LawsonTalk. We hope you enjoy your visit.


You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free. After registration, please check your e-mail within 24 hours for an message from us, read it, and reply to it.


Join our community!


If you're already a member please log in to your account to access all of our features:

Username:   Password:
Add Reply
Web Users, Lid Users, Db Users, Ftp Users...
Topic Started: Feb 6 2006, 01:06 PM (444 Views)
jacflash Feb 6 2006, 01:06 PM Post #1
Advanced Member
[ * * * ]
 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!
Offline Profile Quote Post Goto Top
 
schroncd Feb 6 2006, 11:11 PM Post #2
Member Avatar
Lawson Technorati
[ * * * * * * * * ]
 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.
Offline Profile Quote Post Goto Top
 
jacflash Feb 7 2006, 06:21 AM Post #3
Advanced Member
[ * * * ]
 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.
Offline Profile Quote Post Goto Top
 
« Previous Topic · Security · Next Topic »
Add Reply