Runtime Solution Password Recovery Options..??

I've got a FM solution that I distribute as a runtime.  I have 2 accounts included with the runtime:  admin and user.  Our users use the user account, and the first time they sign in it has them set their own password.  This all works fine.

People forget their passwords, though, and the only answer I've had for them is to uninstall and re-install the software.  Obviously, this is not ideal.

I'm looking into this a little more now and I see there is a script step for resetting an account password.  This looks nice, but we'd still have to be signed in to some other account in order to get access to the script, right?  We could at least do a screen share with the person, log in as our admin user, and then reset it for them, but we can't guarantee 24x7 support, so that's not ideal either.

Is there some other method I could use to make this work nicely for everybody involved?

I was thinking it would be nice to hook the user account system up to the user's local computer instead of using the built in FM accounts.  That way they could manage all their usernames and passwords on their operating system, and those would then work to sign in to FM.  I'm not finding any information about anything like that, though.

Any information on how I could handle this in a nice way would be greatly appreciated.  

LVL 11
Andrew AngellCo-Owner / DeveloperAsked:
Who is Participating?
Will LovingConnect With a Mentor PresidentCommented:
One method of dealing with this is to create a User table which contains a list of the user names, their privilege set and a hint for their password. Note that the table does NOT contain the password itself which remains hashed within FileMaker.

I use a set of scripts, including the various script steps related to Account management that you noted, to add/delete accounts, edit passwords and privilege sets, etc. If your table contains a "hint field" then you will have a method to present that to users if they forget their password. You can also allow someone with Admin privilege set (and I mean a limited Privilege set you have created for users that you call "Admin", not Full Access) edit passwords for user accounts with lower Privilege set access.

For one example of how to manage user accounts using scripts, see:

The are others out there from various sources. I'm not aware of a way to get manage FileMaker's user accounts using the Windows or Mac system level user accounts.

If you need the ability to migrate/import saved passwords from one file set to another, something that FileMaker does not do natively, you can use the Blowfish encryption plugin to save an encrypted version of the password to the User table and then import that to the new data shell and un-ecrypt it to re-create the user accounts.
Andrew AngellCo-Owner / DeveloperAuthor Commented:
Sorry I seem to have abandoned this.  I've been busy on other things and wasn't able to focus on this after posting about it.

I appreciate the info.  I'll be studying it here soon and I'll award points before long if I don't run into more questions.  Thanks!
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.