The users name should be in some field, as u have specified it as the user's data. say the user is the sales person, then u have the field sales person.u can bring in this field too in section access and show them only the others data right.
Correct me if am wrong. or pls explain the scenario.
Hi - Thanks for the quick reply.
Let me clarify a little more on this. I work in HR Analytics and creating a tool that will help assess the performance across the organisation. In the example, they are heads of the region. They can see all the data except their own.
THEY SHOULD NOT SEE THEIR OWN DATA. In other words, I want the access to be taken away for the own record.
I could create a separate fields but, this would mean one field per record like the below.
Access UserID Password REGION EMILYROW DOREROW Admin Admin Admin * * * User1 Dore Pass1 South Asia * EXCLDORE User2 Emily Pass2 Europe EXCLEMILY *
I have more than 50 users so, dont this will be effective solution. Please help.
u can create a special field in your table in the section application, which will show you whether it's user's region or not, by applying a condition like
if (REGION=USERS_OWN_REGION, 1, 0) as ACCESS_FLAG.
Then in section access write:
Access UserID Password ACCESS_FLAG Admin Admin Admin * User1 Dore Pass1 0