We need to restrict some of our users from seeing product costs. Currently these users have access to Part Tracker and Costs is a tab there…
We would prefer to do this at the table-level, so that wherever costs could show up (Method Tracker, Quote worksheet, etc.), these users cannot access them. So, I want to create a security group called “Can View Costs” (or “Cannot View Costs”, depending on which list is bigger).
I have looked at the following options, but cannot figure out which is easiest to implement and maintain.
-
Table Security. Cannot find a way to secure the whole table. There does not appear to be a business object PartCost in Service Security Maintenance. There is PartCostSearch but that does not appear to be the same thing (maybe it is?)
-
Field Security. There are around 30 fields in Part Cost and I have not found a DMT template that handles field security. I could slog through each manually, but would prefer not to.
-
Custom version of Part Tracker (removing tab). This would handle the Part Tracker, aspect, but not BAQ, PartTran records, Method Tracker, Quote worksheets or and anywhere else that I don’t know about. We would prefer not to have customized versions, if we can avoid it (we do have one or two, but mostly use the “out of the box” versions.
Anyone have opinions the best approach to take on this? I would appreciate your thoughts.
Thanks.
—sam