I know MS has screwed us on this one, but I was wondering what is the best agreed upon solution to allow users to not only submit an InfoPath form to a form library in SP, but also then to restrict them to only be able to view and edit their own forms, rather than everybody's forms as the 'Contribute' permissions allow?
Currently, we are manually editing the permissions for each item/form before approving the form, so that only Site Owners and the user who created the form have access to the form, and manually removing the Site Members (Contribute) permissions. We have set the permissions so that while the form is still in 'Pending' or 'draft' status, only Site Owners and form creators have access to the form, but of course this option is not available once the form is approved.
This is an extranet site and we have already had one malicious attack, and we already have over 400 forms in the library, so I definately need the best 'coded' solution to ensure maximum security...
Which coded solution do you like the best? Has anybody done this before in Visual Studio with a custom workflow using C#?
Thanks in Advance,
David