Page 1 of 1

Multiple user levels (v2021)

Posted: Mon Nov 13, 2023 3:50 am
by sclg

Say I have user level A which allows read access to table 1
and user level B which allows read/write access to table 2.

If I give a user level A access, they can see table 1.
If I give them Level A AND level B, then they have R/W access to table 2 BUT they can no longer see table 1 - not even in the menu.

User level B ALSO allows read access to table 1.

If I set the user to EITHER level A or B, they can read table 1, but if I set them to BOTH levels, then they can't.

This seems wrong to me. Am I doing something wrong?


Re: Multiple user levels

Posted: Mon Nov 13, 2023 9:38 am
by mobhar

You better create another user level which have your desired permissions to the tables that suits your needs.

In addition, you may use Recordset_Selecting server event to allow access records for that user level above.


Re: Multiple user levels (v2021)

Posted: Mon Nov 13, 2023 5:47 pm
by sclg

I can do that but it would be nice to know how multiple levels are supposed to work.