Export users and privileges to a text/csv file?

[gregm1]

I could do with a script to export all user names and privileges to a text file for an access review. Anyone know of a way?

Cheers

[Agnes Riley]

If you're talking about the FileMaker security structure, there is no way to export them.

You can however scrip account creation and store all your user's user name (I would never store passwords) in a table in FileMaker with their privilege set. Then you can do whatever you want with that info, even export it.

[Wim Decorte]

you could run the DDR in XML format and write a stylesheet to convert it to excel or Word... Or you could buy BaseElements, import the XML DDR and do an export from BaseElements.

[gregm1]

Someone else has suggested using the

database design report in Advanced, but I haven't had time to look into it. I just printed a load of screen grabs this time, not elegant but quick.