SQL Management studio, The SELECT permission was denied on the object

Try this-

1. Login with the sa user (sysadmin)
2. In Object Explorer, expand Security and then Logins
3. Right click on the user from the list and click Properties
4. Click User Mapping and then click on (select) the Database from the list
5. Now you can see a list of Database role membership for : Your DB Name
6. Make sure that db_datareader is checked and db_denydatareader is unchecked
7. OK

Hope, It helps :)

Reference:
db_datareader[^]
db_denydatareader[^]