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.