AnsweredAssumed Answered

Find returns records with <no access>

Question asked by djwait on Aug 21, 2013
Latest reply on Aug 22, 2013 by philmodjunk


Find returns records with


FileMaker Pro



Operating system version

Windows 7 Pro 64 bit

Description of the issue

User with restricted view permissions performs a find; filemaker returns records with (which are the records that the user should not have access to)

Steps to reproduce the problem

- setup file with several records
- allow at least two users; one with full access, one with restricted view & edit to some subset of the records
- check that restricted view & edit work (that is, a "show all" will return records with )
- with restricted user access, perform a find with a wildcard (or really, any valid find request) and see that records still show up

Expected result

Expect a Find to not return records that user does not have view access

Actual result

Find requests executed with a restricted user permissions still return records with

Exact text of any error message(s) that appear


Configuration information

I am trying to make it so that the restricted access user does not see the records, by performing a scripted Find when the user accesses the file. Interestingly, it seems like the Find re-sorts the records (though it still returns records with )

Attached image, top to bottom; a table view of the test file, first will the full access user logged in. Then a table view of the restricted access user logged in (restricted to CIR_v3::Last_Change_Name = "djwait"), then the same view after I run the login script for the restricted access user (which performs a Find, CIR_v3::Edit_Status; "*").

Script steps:

Enter Find Mode [ ]
Set Field [ CIR_v3::Edit_Status ; "*" ]
Perform Find [ ]