Contents tagged with Acumatica security bit mask explanation
this post is dedicated to understanding how security in Acumatica works. If to be precisive security of accounts.
Let's say you need in some way filter accounts for some user according to configuration at row level security screen ( GL104000 ).
In my case I had following records in database which correspondent to the following numbers:
Relation group mask : 16; 0; 0; 0
User group mask: 159; 96; 0; 0
Account group mask: 16; 0; 0; 0
How to join them? They are joined not by separated table, which has relations between groups and accounts or groups and users, but with usage of bit mask. It's very effective way to join and is much faster then holding adta in db. But the most … more