RE: DB2 Users

["Reinardy, James" <jreinardy@xxxxxxxxxxxxxxx>]

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/)