FMS 16 in a 2 server set up.
User accesses a DB via WebDirect, in the process of a script, a related DB is queried for some data that is returned and stored in some variables.
Does the related DB have to be accessible via WebDirect?
Yes. All databases (even if just referenced) that are used for WD must have the permissions to do so. If you wish, create a limited set with the privileges to ONLY do what is needed for this activity. Then make sure the accounts in the first file are duplicated in the second file (with the same passwords) but set to this limited Priv. (which would include WD enabled).
Yes. The account that access the main file also needs to have an account in the other file and the priv set for that account has to allow WebDirect access.
Retrieving data ...