Importing users from a separate file

[stph6]

Is there a way to import database users from file into another so that I do not have to recreate all the accounts on each file in my solution?

[Fenton]

You could create (or use) a table for Users and their accounts. Then script the creation of accounts in all the files. If you can create one, you can create a Loop which does many. It is quite fast. Look at this example file.

http://www.fmforums.com/forum/showtopic.php?tid/112882/post/112911/hl//fromsearch/1/#112911

This is not a highly secure model however, because it stores the user passwords. To make it more secure, delete the user passwords from that field after everyone knows theirs; they are no longer really needed once the accounts are created. Or, even more secure, modify the setup so that users have to modify their password the first time they log in.

[Tim W]

Hi stph6,

Sadly, no not in an import fashion. The process can be scripted though. Each Privilege Set must be manually entered, cannot be scripted and must be identical from file to file. After that, users can be set up in each file via a script. I use such a scripted process in my systems.

Some start each file from a template with privilege sets already created.

Hope this helps,

Tim

[Steven H. Blackwell]

Use External Server authentication instead. This is one of the scenarios for which it is explicitly designed.

Steven