Debtor visibility to specific users

[Ernst]

Hi Mike,

Had you had a chance to look at the plugin yet.

Any thoughts on the Inventory Maintenance question?

Thx,

[Mike.Sheen]

Hi Mike,

Had you had a chance to look at the plugin yet.

No, not yet.

Any thoughts on the Inventory Maintenance question?

Only way to tackle that is to also impose RLS on the rows of the other tables, such as IN_DebtorSpecificPrice. Should be fairly simple.

[Ernst]

We dont need to limit what they can see on the price tab, as the whole price tab is hidden anyway. We just want them to get access to the inventory record.

Do you think the same limit to debtor specific table, would make it work. And not create the inventory read error. If you think It will, then I can give that a go.

[Mike.Sheen]

We dont need to limit what they can see on the price tab, as the whole price tab is hidden anyway. We just want them to get access to the inventory record.

Hiding the tab won't stop the business logic backing the form from trying to read the data and the problem to arise.

The error you get when opening inventory maintenance is caused by DB_Main rows being linked to IN_DebtorSpecificPrice rows - and which the RLS predicate function for those DB_Main rows, for all intents and purposes, thinks do not exist, so the attempt by the inventory business logic to read the IN_DebtorSpecificPrice table data and then resolve the debtorID by reading the debtor from the IN_DebtorSpecificPrice.DebtorID is throwing a Record Not Found exception.

So avoid that, we would need to make the IN_DebtorSpecificPrice rows also, for all intents and purposes, to not exist so they aren't read and there is no subsequent attempt to resolve a DebtorID which, for all intents and purposes, does not exist.

Do you think the same limit to debtor specific table, would make it work. And not create the inventory read error. If you think It will, then I can give that a go.

Yes - as above. other tables might also need to have the same employed - you'll find out soon enough if that is the case!

[Ernst]

OK thanks for the update and explanation, Will give that a go, and let you know how it works out..