Hey everyone! I'm working with an ERP system where documents are essentially links to files stored on a network share. For example, invoices are kept in a dedicated folder called 'Invoices'. While some users need access to these files, they often don't realize that opening the folder directly in File Explorer will show them all invoices. I'm concerned about users potentially accessing more files than they should.
Ideally, I'd like to restrict access so that users can only view specific invoices through ERP. I've considered using Sharepoint for unique file links, but that's not an option due to internet speeds. I've also heard about storing documents directly in the ERP database, but was advised against it because it could negatively impact performance. What options do I have to safely manage access?
1 Answer
You could explore using NTFS permissions to manage access. By setting Windows permissions on the share, you can restrict users to read-only access for specific files while preventing them from viewing folder contents. This way, they'd only be able to open the files through the links provided by the ERP without seeing other files in the folder.
So with read-only permissions, a user wouldn’t see any files when they access the folder, but they could still open specific files directly if they have the path? That certainly seems like an improvement over the current setup!