Record Access when connecting 2 Filemaker Databases

[ejpvi]

I am trying to figure out what I need to configure to fix this.

I have 2 Filemaker Databases on the same Filemaker Server. In one of the databases, I added the other database as an external data source.

I then created the table occurrence, and built a relationship.

It is accessing the other database fine.... but what is weird is that it never prompted me for a password or username, and no matter which user is logged in, they have access to edit the other database.

How am I to prevent them from editing the record in the other database without locking them out completely.. I can't find where to configure it.

Now, coincidentally, my admin account has the same password in both databases, so I considered that to be a reason why it didn't prompt me for a password...but I would be surprised if that was the problem here...

[bcooney]

I'd check File Options for a saved login.

[ejpvi]

is there a another file option setting that I am missing?

The issue only occurs when connecting to another filemaker database through table occurences

[bcooney]

What are the Accounts and Privs in the files? Do you have any RLA rules?