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

[angelleye]

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!

[angelleye]

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

[Fenton]

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.

[Steven H. Blackwell]

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

Yes. It is a major functionality of FileMaker Server. See the External Server Authentication White Paper found here.

Steven