AnsweredAssumed Answered

access privilege issue in filemaker 10 pro

Question asked by csavage on Feb 10, 2009
Latest reply on Mar 3, 2009 by TSGal

Summary

access privilege issue in filemaker 10 pro

Description of the issue

FileMaker Product(s) involved:FileMaker Pro 10v1Operating System(s) involved:Windows Vista and Mac 10.4.11 Detailed description of the issue:Using the privilege set to limit edit access to certain records is producing wrong results.  We have two privilege sets created: TEST and TEST_MGT.  The following formula is being used to determine access to the records. Exact(Upper(priv_set);Upper( Get(PrivilegeSetName))) or Exact(Upper(Get(PrivilegeSetName));Upper("TEST_MGT")).  When a user is a member of the TEST_MGT group, they should have access to edit the records of both TEST and TEST_MGT.  When testing, the error message appears “Your access privileges do not allow you to perform this action.”    Exact steps to reproduce the issue:1.  Create a database2.  Create the following fields: field1, field2, field3, and priv_set. 3.  Create Privilege sets: TEST and TEST_MGT4.  Change File > Manage > Accounts and Privileges > Edit Privilege Set, click on Layouts. 5.  Change to All modifiable.6.  Click beside Records: Create, edit, and delete in all tables.7.  Change to custom privileges. 8.  Then click on edit for the given table name. At the bottom where set privileges: click on the drop down for edit and choose limited. 9.  Enter the above formula. Click OK to accept the changes.10. Repeat step 4-9, for privilege set TEST. 11. Click File > Manage > Accounts and Privileges > New. 12. For the Account Name and password, enter user1. Change Privilege set to TEST. Click Ok.13. For the Account Name and password, enter user2. Change Privilege set to TEST_MGT. Click Ok. 14. Create 3 records: record 1 should have TEST in the priv_set field; record 2 with TEST_MGT in the priv_set field; record 3 should have [Full Access] in the priv_set field. 14. Close the file. 15. Open the file with filemaker pro 10 using account user2 and password user2. Attempt to make changes to records 1 and 2. Expected Result:Filemaker Pro 10: Edit access should be given for records 1 and 2 using account user2. Actual Result:Filemaker Pro 10: No access is given to edit the records. Exact text of any error message(s) that appeared:“Your access privileges do not allow you to perform this action.”    Any additional configuration information/troubleshooting that is relevant to the issue:Using Filemaker Pro 9: Edit access should be given for records 1 and 2 using account user2.Using Filemaker Pro 9: Edit access is given to the records.    Open the file with filemaker pro 9 using account user2 and password user2. Attempt to make changes to records 1 and 2.  Access in given for editing records 1 and 2.

Outcomes