Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macola User security report

Status
Not open for further replies.

JDMiller

MIS
Feb 17, 2004
60
0
0
US

I have multiple data companies, multiple users per data compnay, each user has specific access to Macola processes. Some users have access to multiple data companies. I am trying to create a simple Crystal report that lists the following:

User Name, Data company, Module access at the highest level - example ABLACK 46 AP. I do not need to know the specific AP functions the user has access to. I have tried a number of combinations using the syscomp and syspass files but just can get anything to work. What am I missing and are there other tables that contain this information? Thanks for any assistance.
 
As a starting point, you might want to read up on this previous and similar discussion: thread639-456204

It is not a pretty picture.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top