Re: Need help understanding Mapics security
"LeLeux, James" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <03B42F10470C7A47B3571990353A253B09019B62B0@JKVMAILBOX1.spsfastener.com> |
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 [email protected] -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] 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-/[email protected]] 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 <[email protected]> To: MAPICS ERP System Discussion <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> 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-/[email protected]] Sent: Friday, October 22, 2010 7:16 AM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.