Is there a way to add/edit user accounts in all files at once...???

May 30, 200718 yr

We've got about 20 FM files that all work together as our entire solution...it's been developed over the last 12 years or so way before you could put everything in 1 file and is a scary thought to try and consolidate now.

I need to make some changes to accounts and privelages but maintaining this across all files is somewhat of a pain.

I'm curious if there's some kind of trick or tool out there that allows me to edit all of them at once.

If there's a way to do it via the CWP/XML I'm comfortable with that.

Any information would be great. Thanks!

May 30, 200718 yr

Author

Also, is there a way to tie Domain users into and just add each domain user to a privelage set in FM?

May 30, 200718 yr

You can script the creation/deletion of accounts, and assignment of Privilege sets. You cannot create a Privilege set via a script, as they are table-dependent, with lots of options. So, do whatever to the privileges sets first.

You can control the process in all files from a central location. You need scripts there to do that. You also need a few scripts in the other files. Since those are all based on a same-named table occurrence to the central file's table, the "other files" scripts can be copy/pasted and will work as is; though you may need to tweak the privilege set choices, if they are not uniform throughout. You cannot specify a Privilege set by calculation, so you end up with a series of If tests.

I have a couple of examples in the Sample Files section. They are "light" security versions, ie., the passwords are stored in the file, they are not changeable by users. A more secure version would not store the passwords, but would let (force) users to change them the 1st time. I been meaning to make an example of this, but haven't gotten around to it.

Or use External Authentication. I've not done this, but others can answer questions about that.