title: How to create a read-only server role on SQL Server 2012?
body: <p>I am granting the "View any database" permission when creating a new server role, but realized this permission only allows the user to view the system databases. </p>
  
  <p>I am trying to create a server role that is read-only and can read any database.</p>
  
  <p>Is there a way to create a user-defined server role to read user databases? Or do I have to do this through user mapping per user?</p>