IIS Error: The SELECT permission was denied on the object

Last Reply one year ago By dharmendr

Posted one year ago

Hello All, 

My Site IsWorking Fine before 3 days on server .

i change my server brfore 3 days and error comes of denied permision of database 

please give me soe sggestion to solve this error 

SqlException: The SELECT permission was denied on the object 'Review_Rating', database 'myeasyshikshadb', schema 'manohara'.


Posted one year ago

Try to run the grant query though sql management studio

GRANT INSERT, UPDATE, SELECT ON TableName TO UserName