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 |
|
sjmann11
Starting Member
1 Post |
 Posted - 2008-03-18 : 11:33:36
|
| It is my understanding that you grant select permissions to a view for a user and they should be able to select from columns in that view. However I have done that and they receive permission denied when trying to select from that view. Am I missing something? I shouldn't have to grant permissions to that table or the database for them to select. Thanks in advance for the help. |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-03-18 : 15:00:33
|
| have you tried sp_grantdbaccess to try and get the access to work |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 00:07:15
|
| >> I shouldn't have to grant permissions to that table or the database for them to select.Yes if view is in same db with and has same owner as underlying table. |
|
|
|
|
|
|
Permissons to a view