Thanks for sharing this Greg. I'll use this query as a basis to create
a report of who has task type MNT, which I've never done before.

However, I just want to point out that just because a user has an option
doesn't mean she can use it; she needs to be authorized to the task

Bryan Burns

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Greg Wenzloff
Sent: Monday, October 25, 2010 7:02 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Need help understanding Mapics security


We create a file as part of our SOX audit.
Try this ... see if it gives you something useful:

create a query
file 1 - MZBRRES2
file 2 - TSKDEFL0
2=Matched records from primary file

choose fields - we use

Seq Field Text
10 T01.BRBUCD Userid
20 T02.APLATS Application abbreviation
30 T02.TSTYTS Task type
40 T01.BRSKXX Task ID
50 T01.BRBTXX Sub task ID
60 T02.TSDSTS Task description

Sort results - we use

Prty A/D Field Text
10 A T01.BRBUCD Userid
20 A T02.APLATS Application abbreviation
30 A T01.BRBTXX Sub task ID
40 A T01.BRSKXX Task ID

Break on userid

Break Sort
Level Prty Field Text
1 10 T01.BRBUCD Userid

Good luck,

-----Original Message-----
From: Richard Reeve [mailto:richreeve@xxxxxxxxx]
Sent: Saturday, October 23, 2010 3:45 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Need help understanding Mapics security


Please forgive my ineptness where Mapics is concerned. What I'm
task at doing is producing a file that contains a specific users
authorized menus and all authorized options on that menu(s). Are you
telling me that Cross Apps/Maintenance-Change/Security
Maintenance/Generate Reports capable of doing this (producing a file
rather than a report)? If not, can you give me a little guidance as to
which files I should be looking at?


Warmest Regards,

Richard Reeve

From: Greg Wenzloff <GWenzloff@xxxxxxxxxxx>
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Sent: Fri, October 22, 2010 7:43:47 AM
Subject: Re: [MAPICS-L] Need help understanding Mapics security

Why not use Cross Apps/Maintenance-Change/Security Maintenance/Generate
Reports Available in XAR4 --- should be in later versions too.


-----Original Message-----
From: Richard Reeve [mailto:richreeve@xxxxxxxxx]
Sent: Friday, October 22, 2010 7:16 AM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] Need help understanding Mapics security


I have been tasked with writing a connector to list the
menus/options that each user within Mapics is authorized to. Can anyone
point me in the right direction as far as which files to use to retrieve
this information?

Thanks so much.

Warmest Regards,

Richard Reeve


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.