Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement wherein the user can see data as specified but, should not be able to see his own record. For example, let's take an user "Emily". She will have access to region "Europe" but, since, she is in "Europe". She cannot have access to her own data.
Access | UserID | Password | Region |
Admin | Admin | Admin | * |
User1 | Dore | Pass1 | South Asia |
User2 | Emily | Pass2 | Europe |
In the above table, 'Dore' & 'Emily' should be provided with access as specified but, not self. How do I achieve this through Section Access? Or is there any other way?
Thanks for your help.
Regards, M
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.
Regards,
Sundar
Try Below
Access | UserID | Password | REGION |
Admin | Admin | Admin | * |
User1 | Dore | Pass1 | South Asia |
User2 | Emily | Pass2 | Europe |
Make sure in document properties -->op open tab--> Initial data reduction based on section access, Initial selection based on section access are selected.
Regards
ASHFAQ
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.
Thanks, M
Hi M,
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 |
Wow.... that's innovative. Yes. I think this should do the trick. I will try it.
Thanks Kristina.