Limit acces criteria

[Tom Assia]

Hi everyone,

I'm working on an existing database of customers (more than 10 000)

Managers want to limite access with condition customer account manager (field in each records) = Connected user

But all the customers are in one table so when performing search query, all records are displayed.

I tried to set permissions but user saw <record missing> for record they don't have access. It's not really clean for UX.

So how do you manage this ? With a script for each query ?

Thanks

Tom

 

[comment]

35 minutes ago, Tom Assia said:

when performing search query, all records are displayed.

When you perform a find - any find - records to which the current account has no access are automatically excluded from the found set. The only way to show <<no access>> records is the Show All Records command. This needs to be replaced with a bogus find, e.g. searching for * in a field that cannot be empty.

 

[Tom Assia]

Thanks for your reply.

I have to change many many scripts.

Tom