title: Allow user to open file in Windows file system only if they can see the file in an SSRS report
body: <p>We have a repository with two parts:</p>
  
  <pre><code>File System: holds documents (PDFs) in folders divided by date added.
   SQL Server: holds metadata and the path of each document. (User permissions
               would be based on the metadata held here).
  </code></pre>
  
  <p>The file system is presently locked down so nobody has access.  We are hoping to grant users access to files via a SSRS report.  The report would query the database and return a list of only the documents that the user should have access to.</p>
  
  <p><strong>How would we grant permissions to the user only for the files retreived by the report?</strong></p>
  
  <p>Thank you!</p>