Quote Originally Posted by dbasan
Create a Role granted with SELECT any tables,..........and grant this role to the users you need.
think about your answers - its the same user