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 |
|
mobasha
Starting Member
45 Posts |
 Posted - 2007-07-23 : 03:14:06
|
| hi every one i have a view it reads from four tables and i want the user to read from it with out having a read permetion on those tables, i was thinking in a way to make the view read from those tables in different permetions ,like this the user is john and when he read from the view he will do so using scott permetions. can this been done and how, if not what other solutions that i can do >>>> please help me in this ... and hanks alotMobashA |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-23 : 13:44:38
|
| Users don't need permission on underlying tables if view and related tables have same owner, just grant select permission on view to user. |
 |
|
|
mobasha
Starting Member
45 Posts |
Posted - 2007-07-24 : 03:45:05
|
| ok good i will try this ..thanks alotMobashA |
|
|
|
|
|
|
view permetion