IIS Error: The SELECT permission was denied on the object

ps222
 
on Feb 25, 2019 11:21 PM
3523 Views

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'.

Download FREE API for Word, Excel and PDF in ASP.Net: Download
ps222
 
on Feb 25, 2019 11:49 PM

I also trying with fire this on my sqlserver
but my site is live ad databse on server plesk server 

Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

dharmendr
 
on Feb 26, 2019 12:54 AM

Try to run the grant query though sql management studio

GRANT INSERT, UPDATE, SELECT ON TableName TO UserName