I am using the Create Login Page option with the usernames & passwords being pulled from a table in the DB.
I have an additional field in the Users table (called Access), which I have used to group the users into different levels of access (FullWithDelete, Full, ReadOnly, Disabled). In the User Group Permissions form I have created 4 groups and have given each group appropriate permissions on the tables.
The ReadOnly group should not be able to Add/Edit/Delete on any tables but when I log in as a ReadOnly user I can still do all these actions.
The Full group should be able to do everything except delete. They can delete records.
When I create a user in the Disabled group I cannot see any items in the menu page, which effectively means that the Disabled group is working (they do not have any permissions on any tables).
Why do the ReadOnly and Full groups not work?