Access secured databases from another database

I'm currently working on a FileMaker solution with different databases. These databases should be password protected. They don't need to be accessed directly. There is one main file (with different security levels) and this should be the only one that is capable of opening the other databases, without asking intermediate passwords.
Any idea how to implement this in FM?
Zorro032798Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

weedCommented:
If it's password protected there's no way to access it without the password. Wouldnt be much point to password protecting it otherwise.
0
Zorro032798Author Commented:
yes, I agree, but in a multi-table design it should be a good thing to secure all the tables and at the same time make them only accessible by the main table, for which you provide a password once. So I am looking for a way to pass this password from one table to another without prompting the user when a new table is opened.
0
weedCommented:
As far as I know, you cant. There just isnt a way to have related tables auto-password.
0
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

Zorro032798Author Commented:
Well, since the answer was negative I tried it myself. And indeed, if two or more connected tables use the same passwords, the same authentication levels are recognized in the related files, without prompting again for a password. If you use different passwords it won't work.
The files are completely protected and cannot be opened without password, but once logged in a user can access all the dependent files.
0
weedCommented:
Er, the answer was "you cant". Sometimes that's the right answer.
0
Zorro032798Author Commented:
but in this case it wasn't. I'm sorry.
maybe consider not to provide answers in case you don't know. after all people come here to win time. they rely on expert advice. and it isn't much of an advice to tell someone that it is not possible in case you don't really know it.
0
weedCommented:
But i did know...heh. The only loophole you found was if they had the same password.
0
Zorro032798Author Commented:
yes, ok, no problem. the most important is that there is a solution, and that we both have become a little bit smarter.
0
SpazMODicCommented:
PAQed, with points refunded (250)

SpazMODic
EE Moderator
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Zorro032798Author Commented:
tnx
0
KungFoolioCommented:
Zorro didn't stumble upon a "loophole" as Weed would suggest. The use of matching passwords to "pass" authentication for a multi-file solution is absolutely the way you deploy a secure solution. This insures that you can open all releated files without having to type a password for each. If you did not set up passwords in the related files, a user could open them without using any password.

Sorry I couldn't have answered this sooner.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.