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.
midrange.com
