I had the same problem, because the user had the db_denydatareader property checked.

I unchecked the property and it worked well.