I'm trying to find a way where I can set the credentials used to access an external FileMaker Data Source that would be different form the credentials a User used to log in to the "local" file. We have a number of FileMaker databases that act as repositories for various types of information around our workflows. I'm working on a file that needs to be able to use some of these files as a lookup source.
I've done this via ESS before, where a set of credentials can be added to the SQL source that's read-only, for example, and these credentials are included in the DSN that's set up for the datasource. I don't see a way to set up something similar for FileMaker's External Data Sources, though, and am wondering if anyone knows of a way. We don't want to have to add a bunch of privilege sets and/or accounts to the "repository" files. Ideally, we'd like just a read-only account there that can be used by a variety of other FileMaker files that may need to look things up.
Thanks in advance for any pointers anyone can provide!