Hi marksystech ,
I may be wrong, but I think such information is not available. Are there so may people that can edit the Layouts (I hope not) ? They could protect the database design by suspending the accounts that are able to edit Layouts.
Inspector Pro can compare two copies of the same file and report on differences. FMdiff can do the same.
I think they are concerned about the rogue employee
If the users have no privileges to change a layout then this is not a valid concern...
And if it still is then the diffing tools as mentioned are the best way to do this.
I worked extensively with a ISO certified manufacturing company that also operated under FDA rules as an auditor, a member of the quality staff AND as FMP developer for enterprise applications.
We never had this requirement come up.
I would just follow Wim's advice to make sure you restrict access with accounts and permissions.
If you can demonstrate to your manager that only you or a small subset can enact potentially destructive/dangerous changes and that you are properly managing the credentials and there assignment that should satisfy an ISO audit.
If you have business needs that require open assess then you have other problems to solve that PMJ provided a good suggestion on.
A further thought to all the helpful comments and advice so far. Does your customer's "quality manager" realise that allowing staff to modify layouts means giving them open access to the file? And does he/she realise that that, in itself, surely runs counter to your (or for that matter the company's) ability to maintain standards of quality and integrity in the database? If I were in your shoes I would respond along that line rather than busting a gut trying to comply with what seems to me to be a daft requirement.
All good advice here. I used to be a "documents coordinator" for a manufacturing plant and ISO compliance was a major part of my job. We never had to do that with any of our database systems and I was often the guy creating/modifying them. But for the engineering and other documents that documented both the design of a product that we purchased or produced and which also documented the production process for each manufactured item we had to track all revisions with a review and approval process that was also logged. With the documents then used, we couldn't control nor automatically track changes at that time, but we did label every specification document with a version ID plus a log that documented what was changed and who had reviewed and approved those changes.
At the very most, I would think that such a log tracking who changed a part of the solution design and who approved the change (and when) in a log should be sufficient.