We used to generate different reports:
1. List of modified objects using DSPOBJD to get creation and last modified date:

DSPOBJD OBJ(PROGRAMS/*ALL) OBJTYPE(*PGM) +
OUTPUT(*OUTFILE) OUTFILE(FILES/SOX_OBJF)

2. Bunch of queries joining MZBRREP and a list of user and TSKDEF to get users with:
- Access to create/maintain item master, Bom, routings
- Access to inventory txn
- Print IFM checks
- Process credit returns
- Maintain payment terms
- etc.
We used to run the reports monthly and get approval from a business owner.


Regards
Antonio Rojas
Sr. Manager Applications Development
Semtech Corp.
(805) 216-4651




-----Original Message-----
From: MAPICS-L [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Webb, Connie
Sent: Wednesday, May 31, 2017 11:21 AM
To: mapics-l@xxxxxxxxxxxx
Subject: [SPAM:] [MAPICS-L] SOX Audit


Does anyone have any tips or technique’s for presenting security information to auditor’s for Sarbanes-Oxley audit?
XA REL 9.1

Connie Webb | Database Administrator | 540.387.5600 x272

Graham-White Manufacturing Co.<http://www.grahamwhite.com/> | Providing Reliable Transportation Solutions℠[cid:image002.png@01D2DA19.1C43F920]

New email address is connie.webb@xxxxxxxxxx

This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential, proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distribution or other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have received this email in error, please notify the sender immediately and delete the original. Neither this information block, the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unless a specific statement to the contrary is included in this message.
--
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-2021 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.