Click here to Skip to main content
11,487,406 members (72,322 online)
Rate this: bad
good
Please Sign up or sign in to vote.
Hi every one i have search a lot for this error
"SELECT permission denied on object 'tablename', database 'db1', schema 'dbo"
but m not getting exact answer, m not able to understand the where the problem lies exactly, why its shows this error and what is solution for that...
Plz help/reply me....
Posted 19-Jul-12 2:08am
Edited 19-Jul-12 3:08am
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

This is because you don't have permission to do SELECT's on that table. Ask your dba to give you permission.

Grant permission sql-script:
GRANT INSERT, UPDATE, SELECT ON YourTable TO User1, User2

Giving and removing permissions in SQL Server[^]
  Permalink  
v2
Comments
Gopal Rakhal at 20-Jul-12 8:20am
   
thanks
AlluvialDeposit at 20-Jul-12 8:26am
   
You're welcome. Pleas accept my answer if it solved your problem :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 9,063
1 OriginalGriff 8,287
2 Sascha Lefèvre 3,334
3 Maciej Los 2,946
4 Richard Deeming 2,370


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 19 Jul 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100