While using one Application following error was getting thrown in Event log and application was not giving the proper results in browser.
” Message Error Message :The SELECT permission was denied on the object ‘xobject’, database ‘xxxxx’, schema ‘dbo’.”
By looking error any one guess that some issue with user permissions , but it was not like that schema is different and users are different in SQL server.
So done following steps to overcome the issue
Use xxxx ( database name )
grant select on dbo. xobject to public ( xobject is the name of table / view)