I am very new to FileMaker but not databases and development. I'm having a problem with Create/Delete in custom privilege sets. Edit/View are working as I would expect. I'm certain I'm missing something glaringly obvious.
I'm currently playing with the 30 day eval of FileMaker Pro 13 and FileMaker Server 13 to create a proof of concept.
For the most part, other than some fumbling and the occasional online search to figure out how something is done in FileMaker compared to other environments, everything is working as I would expect.
Except for custom Privilege Sets. As I said, I'm convinced I'm missing something obvious. Any pointers appreciated.
I'm using External Server (Windows A/D) for user authentication in my privilege set and testing on FileMaker Server 13 via WebDirect. That works. If I'm a member of the group, I can log in. If I'm not, log in does not work.
If I apply the built in [Full Access] privilege set, my external user can do it all. If I use the built in read-only, that too works.
If I create a custom Privilege Set, both viewing and editing work as I would expect. If I say the account cannot view, I can't see records in that table. Conversely, when I say the account can see the records, I can see them. I can even create custom rules for viewing/editing, and those work exactly as I want and expect.
However, I cannot seem to get any custom rule set that allows creation/deletion of records. I even tried effectively copying the [Full Access] ruleset. I granted "Create, edit, and delete in all tables" and "All Modifiable" for all layouts. My externally authenticated user cannot create/delete when using that Privilege Set, but can view/edit all records.
Any thoughts, ideas or suggestions welcome.