The SELECT Permission was denied on the object 'TableName' database 'dbname' schema dbo

Category: ASP.NET
09 Mar 2016 09:20
Joined: 13/08/2015
Level: Silver
Points: 102
Points: 5
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
#765090
09 Mar 2016 10:28
Joined: 03/05/2013
Level: Gold
Points: 15349
Points: 3
Hi Paul,

While execute any query against table, and while run any table against database you must and should have a valid permissions to run that.

As per error details, you don't have access to that particular database, please check with your database administrator and check with him/her whether do you have a permission to execute the query against that database or not. If no, then get the permissions first and then try to execute the same again.
--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/
#765091
09 Mar 2016 10:36
Joined: 13/08/2015
Level: Silver
Points: 102
Points: 1
Yes Mr.naveen you are right i must do it.

But the database is working fine was the last 6 months.

So why now it gives error. That point only i dont know then i get confused.

Thanks with
Paul.S
#765092
09 Mar 2016 10:50
Joined: 05/06/2009
Level: Gold
Points: 10218
Points: 3

Database will work base on the user which you logged in. Check the the user has valid permission.

Check the following

Open SQL Server Management studio
1. Navigate to your data base
2. Select "Security"
3. Select "Users"
4. Right click the user which you are using in your application.
5.select 'db_datareader' inside "Database Role membership" section.
By Nathan
Direction is important than speed
#765096
10 Mar 2016 12:45
Joined: 29/05/2009
Level: Gold
Points: 10183
Points: 3
Hi

Ofcourse check your Particular Database with Table you didnot have proper permission check them

try to administration login from your sql server

may in your sql server many users have one admin user have control so check them give read and write permission particular table after you can create sql server authentication database.
Name : Dotnet Developer-2015
Email Id :kumaraspcode2009@gmail.com

'Not by might nor by power, but by my Spirit,' says the LORD Almighty.
#765100
10 Mar 2016 02:28
Joined: 13/08/2015
Level: Silver
Points: 102
Points: 1
Now this Problem is solved. Database is working fine.

Thanks for all your valuable reply Friends.

Thanks with
Paul.S
#765106
11 Mar 2016 02:19
Joined: 13/06/2007
Level: Gold
Points: 20603

Points: 2
I think the problem is with the user having deny privileges. This error comes when the user which you have created does not have the sufficient privileges to access your tables in the database. Do grant the privilege to the user in order to get what you want, you need to grant user specific permissions such as SELECT, INSERT, UPDATE and DELETE on tables in that database. see below syntax
http://msdn.microsoft.com/en-us/library/aa258909%28SQL.80%29.aspx
Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]

Joined:	13/08/2015
Level:	Silver
Points:	102

Joined:	03/05/2013
Level:	Gold
Points:	15349

Joined:	13/08/2015
Level:	Silver
Points:	102

Joined:	05/06/2009
Level:	Gold
Points:	10218

The SELECT Permission was denied on the object 'TableName' database 'dbname' schema dbo

Email subscription