Record level restriction in Main Table

[Former Member]

Hi Forum,

I have a scenario where in we are maintaining master records related to multiple regions.

We have created users of a particular role to mainitain master records for each region.

Now what I want is when a regional user accesses the master records, I want the user to access records to his region.

I tried using Masks, but this can be set at role level. In my scenario all the regional users are with the same role.

All your suggestions and ideas are highly appreciated.

Regards

Madan

[Former Member]

Hi Madan,

In console, for every user/role there is tables and fields options.

Select the region as restriction value.

This will solve the problem.

If you have problem in doing this as I dont have console access now, I will try to send you the screenshots tomorrow.

Hope it will solve,

+ An

Pls close your questions if answered

[Former Member]

Hi An,

Thanks for your reply.

For the roles, we can apply the restrictions based on Tables and Fields.

For users, this cannot be explicitly set. They are inherited based on the role assignment.

Correct me in case.

Regards

Madan

[Former Member]

Yes Madan,

you are absolutely right.

Roles are on higher level than users.

So the only way is to define separate roles for users regions. Unfortunately I know this way only.

Hope this helps,

+ An