Jeff,
This is a growing problem for my clients as well. I have not found a single way to keep control but here is my list.
- Only the Administrator can save Common Reports
- Reports are driven with Current User filters where ever possible. The organizational hierarchy is built into Quick Base, so you know who everyone's Manager actually is by User.
- Field level access is set by role on sensitive fields
I have not yet tried to blend in the UserRoles() to the report filter, but I am suspicious that will be the next one to use for permissions.
Does your Boss have a unique role in the application? If so then that should eliminate anyone else from seeing the data in the report.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------