The generated application supports data access security. Data security can be applied either at the form level, or the row level, but not both.
At the form level, group permissions can be applied.
At the row level, user permissions can be applied.
The security data is stored and managed in a seperate, dedicated mySQL database, with it's own user interface.
The security model is built to operate in three mutually exclusive modes - Public Mode, Group Mode or Submitter Mode.
Submitter mode is Inclusive or Exclusive.
Group mode is Inclusive of Exclusive.
Public mode permits access without authentication. Data may be accessed without user login.
The three modes are mutually exclusive. A table is defined as having either Group access, Submitter access, or Public access.
Submitter mode applies an inclusive or exclusive restriction to data access.
All logged in users may create a data row.
Each data row may be viewed by the row creator only.
The row creator has full permission to edit or delete a row.
The submitter has exclusive access to the row data.
All logged in users may view the data row.
Group mode applies an inclusive or exclusive restriction to data access.
All group members may create a data row.
Each data row may be viewed by group members only.
Group members have full permission to edit or delete a row.
Group members have exclusive access to the row data.
All members of all groups may view the data row.
Public mode has no restrictions to data access.