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 |
|
Sean_B
Posting Yak Master
111 Posts |
 Posted - 2010-05-10 : 13:03:25
|
| Hi,I've just had the experience of going through a view to determine what databases / tables it is accessing, and then granting permissions on those tables / databases, to specific user groups.It would be nice if it were possible to add an "execute as login" clause to a view, or something similar.I would be grateful if anyone has any advice on this matter, or is the approach I've taken the only way to do this ?Sean |
|
|
|
|
|
granting permissions on tables undelying a view