Rich,

Greg nailed it for you. This is exactly how we extract the authorities for SOX purposes.

We also have personal menus & group jobs, but those are disappearing as more users migrate to Browser.

I highly recommend using a test USER account to make sure that security works as you think it does.
Not having objects locked down or having personal menus can cause unexpected results - especially since MAPICS security is kludgy.

You can also use query to export the data to a file that you can push or pull to another system, so perhaps that can help you achieve your goal?
You can also put it in the AS400 scheduler to fully automate or run via remote execution.


Regards...james


James LeLeux
IT Director: Cherry, Shur-Lok, & SPS Santa Ana
1224 East Warner Avenue
Santa Ana, CA 92705
Cell:  714-929-8063
jleleux@xxxxxxxxxxx


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

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.

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

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.