Re: Record level security

["Peter Dow" <pcdow@xxxxxxxxx>]

Hi Aaron,

My solution is more of a Midrange-L topic -- create 40 logical files (one
for each company) with select criteria to limit the records to each company,
then restrict access to the physical and the logicals.

hth,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

From: "Bartell, Aaron L. (TC)" <ALBartell@taylorcorp.com>
To: <rpg400-l@midrange.com>; <ign_list@ignite400.org>
Sent: Tuesday, October 30, 2001 2:21 PM
Subject: Record level security


> Hi All,
>
> My company has a corporate AS/400 that stores orders that we pass back and
> forth between about 40 different companies.  The orders have sensitive
info
> like credit card numbers and such that shouldn't be viewed by all of the
40
> companies.  In this scenario each of the 40 companies has their own IT
staff
> that writes query tools to view the data on the corporate machine.  Is
there
> a way for me to restrict access so they can only see orders they are
allowed
> to see at a system level? (i.e. They can only see orders where they are
the
> sender or receiver)



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com