I'm looking to see if there are best practices for securing document access via Section Access. In my scenario I have ten documents with section access in each document that limit user access to the respective document. I am finding that managing user access this way is very tedious in that for each access change I have to modify the load script and reload that document to implement the new user access and/or security. I'm looking for an easier that allows me to:
1. Only allow users to see the documents they have access to
2. Quickly change user privileges without having to reload the entire document(s)
3. Easily manage user rights over all documents
4. Report on all user privileges across all section access enabled documents
I suppose using NTFS is the most straight-forward way to go, so I appreciate your thoughts.
Do you have any thoughts on making row/column level Section Access changes on the fly without having to reload the document? Theoretically we wouldn't have to do this often if we are authorizing at the group level, but with specific user access than I can't think of any other way to apply these settings without reloading. Thanks for your help with this!