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

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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.

This mailing list archive is Copyright 1997-2024 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.