Re: Need to restrict User at Record level in file (Is it possible)

[PaulMmn <PaulMmn@xxxxxxxxxxxxx>]

One possible method would be to create logical files over the 
physical file.  All fields included, but each logical file would 
select/omit to include just the records for one branch.  You would 
have to use a selection program of some type to OVRPF each user's job 
to the logical file for that location.

Other than that, you'd have to put logic in each program that 
accesses the file to select records based on the user profile.

--Paul E Musselman
PaulMmn@xxxxxxxxxxxxxxxxxxxx




At 3:08 PM +1000 10/2/08, Beeram, Raghunath Reddy wrote:
> Q: If one file (Say File1) having 30 records, so I need select records
> based on branch and also need to provide access only to that branch
> users(idea is one branch records should not be accessed by another
> branch people though all branched data available in single file. How do
> we restrict date at record level).
> As per my knowledge it is not possible to restrict user at record level
> but if any one of us having better idea to do this particular one, it
> will be great.