Controlled acces on secondary file

[panchristo]

Somehow, I found out I'm stuck on this:

When you need to have access to a table in a secondary file, how do you control access automatically?

I explain myself: If I need to see data from a table in an external file, how can I connect to it with a specific privilege set that will not allow me to change data but only view them?

I don't want to use anything complicated such as External authentication. Just for desktop use.

[Vaughan]

Set up a privilege set in the second file with the appropriate access. Assign this privilege set to a account with the same username and password as the one in the first file.

[panchristo]

Of course! I know I've done this before but somehow couldn't get around it.

So, two privilege sets with the same name but different settings right?

What if I set the password (of the secondary file) to null to give access to more than one accounts from the other end - will it work?