title: How to give a user access to sys.master_files in SQL Server?
body: <p>I need to give a database user read access to the <code>sys.master_files</code> table. How can I do that?</p>
  
  <p>Currently the user has this permissions:</p>
  
  <p><img src="https://i.stack.imgur.com/H4VTX.png" alt="enter image description here"></p>
  
  <p>Calling <code>SELECT</code> on <code>sys.master_files</code> returns an empty result. I also tested the same query with the <code>sa</code> user which works as expected.</p>