Access to registers by record in table

[ucevista]

Hi all.

I've made a web application for my worksheets where I have a table for the worksheet, another table with children records of wrksheet table for the actuations and a table for customers and all works ok (I open a worksheet, select customer and add records of actuations).

Now, I want to grant access to my customers to see the worksheets that are relative to them in read only access. I know I can grant privileges on admin's area but by register owner and the customers will not add any register.

Is it possible to restrict or grant access to registries by a field of a table?

Thanks a lot.

[onoehring]

Hi ucevista,

well, that's not easy - but can be done. Please see these linke (also in my footer) for Field Permissions (viewtopic.php?f=4&t=3308) and Column-Value-Based-Permissions (viewtopic.php?f=4&t=3498).

You probably have created your users as users in your application. You (as admin) can set your group permissions to see all records, but for the group which holds your customers should only see their own records (not the records of their group). Then, once you have created records that you want to show to your customer "A", make sure, you set the owner of that record to customer "A". You can use the setowner function (see AG documentation) for this.

Olaf

[ucevista]

Hi Olaf.

Thanks a lot for your reply.

I'll download yours two projects to see how you did it.

Bes regards.