PLEASE help with security issues

[caro3252]

I hope someone can help me figure out how to get this to work. I created a solution which is base on 15-20 databases the interact with each other. I set up a lunch database which basically opens up 2 or 3 databses which contain the information necessary to run the login script (users database, etc...). My login script only check to see if the username exist and match what is in the sytem, and based on that it opens the rest of the databases..... the problem is that I haven't figure out how to setup access privilages(editing, viewing, deleting) for the files, with a scrip. I can go to the "sharing" section of fm and set up a group or password and control it from there, but I will have to go to every single database and create those same groups and passwords (which is enough of a pain but doable), but then the user has to first enter their username and password to actually access the solution AND THEN enter their password into the message box for every databse that opens (which means that they have to enter their password 15-20 everytime the start the program). is there a way to get the fm to use the password they enter during the login script and use it for ALL databases? they need to be able to browse and edit some of the layouts/databases and some I don't want them to be able to "see" the information on them (but ALL of them have to be open in order for the solution to work :-( )........ my purpose is the protect the source code and setting of the program so I AM the ONLY ONE that can make changes so all my hard work can not be obtained(and any intellectual ownership violated) by simply opening the "users" databse without going through the login script, and from there change the settings. (in the login script I have instructed FM to lock toolbars, menues, and status bar, and the regular users will not figure out how to get to it with out the toolbars, but anyone that have the minimum knowledge of computing and fm will only need a few seconds to bypass my login script... (the files are saved on a network and is administered using the fm server, and there are other people that have access to the server/network and could make changes)......

any ideas?:

[caro3252]

sorry I forgot to also ask if there is any way to create a "runtime" or stand alone aplication which doesn't give them access to the source code, but allows them to use them, with filemaker pro 6?: (I think this is cover in the filemaker developer version, but I only have filemaker pro and was wondering if it could be done)

[Kurt Knippel]

You must setup the passwords and groups in EACH file in the solution. Yes it is a pain in the ass, although Waves in Motion offers a password management plug-in which allows you to manage this in one place.

If you set a "Default Password" in the File Preferences, then Filemaker will NOT ask for a password, but will use whatever password was entered in the first file, as long as that password exists in the other file (if not it will use the default password).

In response to your second question, you can do this with Filemaker Developer.

[caro3252]

thanks.... one more question... is there a way to set up a conditional setting for use of default passwords?: I mean, I'm thinking about setting all the databases to use a default password which will me set to only editing, and other types of command, but for it to not be able to change passwords and other setting...... now, my worry is that if I do that.... do I have a way to stop the loading of the databases if I'm the user, and then tell it to use my password which have access everywhere in the system (maybe during the start up script)