The SELECT Permission was denied on the object 'TableName' database 'dbname' schema dbo
Hi Developers,Am created a project in asp.net with SqlServer(2008 R2) Server Authentication.
Yet it was working fine. But now i am run the project Front end(User Interface), or Backend(sqlserver) using my Local syatem or Live.
it throws the following error like
"The SELECT permission was denied on the object 'TableName', database 'DataBaseName', schema 'dbo'."
But other DataBases are Working Fine.
i am tried lot of time but i did't get output. So if anyone know Please help me how can i give permission or how to i Resolve this problem.
Thanking You
Paul.S