Over the past week, I’ve been working on a project for plate tracking that would create several checkboxes on a screen that many people visit. I needed the checkboxes to be visible for everyone, but I needed to be able to tightly control who had the boxes enabled.
So, I created priviledges and gave them access to my table. I even broke it down by field, for instance, the priviledge below can request a plate, but cannot approve or complete the plate.
However, try as I might, my users had access to the checkboxes even when they shouldn’t.
After trying everything I could think of, I was doing a security search on my table
and I found this:
Now, this was saying that the temBasePattern roles were accessing my table, but I’d never put it in there. After some more digging I found that these roles were accessing the form that I’d modified, and the form had my table as a datasource. Forms have permissions too!
I had to go into update, create, and delete and change the permissions for my table to be read. And then my users no longer had access, and my permissions objects were able to give them access as needed.
Joseph's Code of many colors 