Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cindylee
Yak Posting Veteran
55 Posts |
 Posted - 2011-12-06 : 19:22:34
|
| Hi AllWould greatly appreicate if someone could help me fix "select permission denied on a table error" for an user.I given GRANT ALL and checked using sp_table_privileges ..etc.. The user has select permission on this table but when i try to execute as the user am still getting the "select permission denied error" any help much appreciatedEXECUTE AS USER = 'test_user'SELECT top 1 * from test1REVERT;if i run the above select query for another table it is working fine. The database was moved from another server and i have doneALTER USER 'test_user' .Looking for any help?Cindy |
|
|
cindylee
Yak Posting Veteran
55 Posts |
Posted - 2011-12-06 : 22:20:50
|
| I tried EXECUTE AS USER = 'test_user'SELECT * FROM fn_my_permissions(test1, 'OBJECT') REVERT;I can see UPDATE,INSERT,REFERENCE,DELETE in permission_name column but no SELECTI tried GRANT ALL ON test1 to test_user..but still no luck. Hoping for some advice on where/what to look from here :( |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-12-07 : 03:45:24
|
Did you try giving explicit SELECT permission?Grant Select on test1 to test_user PBUH |
|
|
|
cindylee
Yak Posting Veteran
55 Posts |
Posted - 2011-12-07 : 18:05:10
|
| Yes i did everything. Given select perimission to the schema as well to the database.I tried REVOKE and then GRANT as well. Hoping for some help guysCindy |
|
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2011-12-08 : 00:26:23
|
| Try removing the user and then re-instating them, I've had a users profile become corrupt previously and this worked for me. |
|
|
|
|
|
|
SELECT permission denied error