It's not a small undertaking, as you have probably already figured out.
One complication is that BPCS security only recognizes the first six characters of a program name so you can't just look at the files that store BPCS user authority information to accomplish this. Furthermore, if you've renamed BPCS programs (e.g. because you've customized something), then you can't rely on the universe of "vanilla" BPCS programs as a starting point for a thorough analysis.
I'm going to speculate that an auditor asked a question and you are attempting to answer while he/she is impatiently waiting. Given that not-so-much-fun assumption, here's two suggestions:

a. If you want to see all users who have authority to a program that appears on at least one BPCS / ERP LX menu, then a product called "By Invitation Only" would help. It will immediately tell you all the users that have authority to a program name you enter. (URL: www.unbeatenpath.com/software/bio/BIOnly.pdf ). You can get a free demo later this afternoon that would help bail you out.

b. If the root of the auditor's interest is a separation of duties subject, then a product called "Due Diligence" will provide an extremely comprehensive listing of every conceivable conflict of interest which has the same USER ID authorized to each end of the conflict. (URL: www.unbeatenpath.com/software/duediligence/separation-of-duties.pdf )

Warm regards and peace to you
Milt Habeck
Unbeaten Path
(888) 874-8008

+++++++ +++++++ +++++++ +++++++ +++++++ +++++++ +++++++
From: SRohatgi@xxxxxxxxxxxxxxxxxx
Sent: Wednesday, May 11, 2011 10:24 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] BPCS Access by Program

Hi There,

Has any one written a script which can identify list of all programs a user has access to? I would like to this for all active users.
We are on v 8.1

Thanks in advance for your help.

Enterprise Applications Team Lead - Supply

Mother Parkers Tea & Coffee
p: 905-279-9100 ext. 2232
f: 905-279-9821

As an Amazon Associate we earn from qualifying purchases.

This thread ...

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.