Rich,

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
BRSKXX EQ TASKTS
BRBTXX EQ SUBTTS

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


Sort
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,
Greg

-----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

Greg,

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?

Thanks.


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.

Greg


-----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

All,


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



_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/mapics-l.



_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/mapics-l.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2022 by midrange.com 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.