RE: DB2 Users

Have BPCSMENU be the initial program and *Signoff the initial menu for 
your BPCS users.     Then limit their capabilities.   If the user can not 
get to the command line how can the run a query or sql?


Roger Henady



"Reinardy, James" <jreinardy@xxxxxxxxxxxxxxx> 
Sent by: bpcs-l-bounces@xxxxxxxxxxxx
06/09/2004 03:55 PM
Please respond to
"SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>


To
"SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
cc

Subject
RE: DB2 Users






Pardon my ignorance of iSeries security concepts here.  All of our BPCS
users are grouped with the SSA profile as recommended.  If I understand
your comment correctly, this allows them full access to the DB2 files
while logged into BPCS.  Does it also allow full access from other tools
like AS400 query and ODBC? 

If so, that is where we perceive our problem to be.  We are being
pressured to control access to the files through means other than the
BPCS screens, even for users within the SSA profile.  Is this possible?

Thanks for replying,

Jim

-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx]
On Behalf Of RKHBIT@xxxxxxx
Sent: Wednesday, June 09, 2004 3:44 PM
To: bpcs-l@xxxxxxxxxxxx
Subject: Re: DB2 Users

Jim, if you followed SSA's recommendation and grouped your BPCS users
with the SSA profile then as long as the SSA profile has authority the
user grouped with SSA will have the necessary authority while executing
any BPCS  object.
 
Utilizing objects outside of BPCS to process the files would also work
for those users grouped with the SSA profile.  Users not grouped with
the SSA profile would require the group attributes to be set to the SSA
profile or to be individually included with each files authority list or
profiles. 

Richard Kent  Hamilton

Business Information Technology,  Inc.
Phone (812)883-9180
_RKHBIT@xxxxxxxx (http://RKHBIT@xxxxxxx/) _BITECHUSA.COM_
(http://www.bitechusa.com/) 



_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.