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?
 
SpazMODicConnect With a Mentor Commented:
PAQed, with points refunded (250)

SpazMODic
EE Moderator
0
 
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
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
weedCommented:
As far as I know, you cant. There just isnt a way to have related tables auto-password.
0
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.