AnsweredAssumed Answered

Custom Privilege Set Bug -- Reproducible, FmPro 10, 9, 8.5, etc...

Question asked by AHunter3_1 on Jun 26, 2009
Latest reply on Jul 10, 2009 by TSGal

Summary

Custom Privilege Set Bug -- Reproducible, FmPro 10, 9, 8.5, etc...

Description of the issue

Please try this as described but NOT on your production db:a) Create a table.  Do go ahead and create a few fields within it.b) Put MORE THAN ONE occurrence of that table on your rel graph.  Just to make things interesting, don't name ANY of those TO's with the exact same name as the table itself.c) Create a privilege set with custom privileges for record access; for editing on THAT table, enter a formula that references one or more fields in that table.  At the top of the space where you define that formula, note the dropdown labeled "Evaluate this calculation from the context of ___" and make note of which table occurrence it defaults to.d) After exiting out of Access Privs, go into Manage Database and delete the table occurrence used in the "evaluate this calc from the context of" as described above.  e) Go back into Access Privs and drill down via that priv set thru custom privileges on records to editing privs on that table once again.  It should now show  for "Evaluate this calculation from the context of ___" and the formula should have changed to something akin to " = 1" , i.e., your referenced fieldnames will be replaced with "".  As you would expect would be the case.f) So now try to click the dropdown "Evaluate this calculation from the context of ___" and switch to one of the [i]other[/i] table occurrences of that table you created, so that you can re-enter your formula.  Doesn't let you, does it?  You can work around the problem by switching the priv set from "custom" to one of the standards (e.g., "can create, edit and delete in all tables") and OK your way out of Access Privs, then go back in and set it back.  But if you do that, prepare to re-enter every single formula for every table that has a formula for view, edit, or delete.   

Outcomes