Filemaker 13 permissions Sets
Here is our filemaker setup:
One Data file
Multiple interface files for various business needs such as:
I would like to use a table to store user information such as username and password, I would also like to have another related table to define user groups. Based on which groups a user belongs to they would have access to those tables specified in a permissions field. Such as Inventory Create/Read/Update/Delete, Asset Create/Read/Update/Delete and so on. Where Create/Read/Update/Delete are checkboxes.
So a user would have the ability to belong to one or more groups and each group would have the permissions to perform various Create/Read/Update/Delete actions on each table.
I assume I cannot use filemakers privilege sets since a user can only belong to one privilege set per user.
Is there a way to do this in filemaker 13?