I suspect the answer is no but is there a way to extract the updates rights from another table?
What I want to do is to be able to assign updates rights to a table based on what they are for another table. For example, if a user has certain update rights to a certain table, it would be handy to assign the same update rights to a child table without having to repeat the formula used to produce the update rights in the parent table.
This is not a must as it is possible to just repeat the formulas used to produce update rights for each table but it would be pretty convenient.
You can create a User table containing the user’s email with access privileges correctly set and then you can refer to this value with a LOOKUP() expression to fetch the user’s privilege on any particular table.
The challenge here is that the app is supporting a process that lasts a couple of months and user will come and go all the time so I would have to update the user right table pretty much every day and it would most likely to out of date.
I haven’t understood why user access mode had to change each month but you can easily change them thru the app very easily. How many user’s you have? You can even put a time limit for an access mode i.e. between dates ADDS_AND_UPDATES, otherwise READ_ONLY etc.