Runtime Solution Password Recovery Options..??

Posted on 2012-09-14
Last Modified: 2013-01-14
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.  

Question by:Andrew Angell
    LVL 24

    Accepted Solution

    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.
    LVL 11

    Author Comment

    by:Andrew Angell
    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!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now