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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2003-03-27 : 10:10:12
|
| I am using SQL server 7 and want to give someone access rights to be able to execute views and to look at the code that defines the views but not to be able to alter either the code or the data that is being viewed. If I give SELECT access to the views does that stop the data being changed? I don't want this user to have access to the underlying tables. Additionally I have no idea where to start with stopping her from changing the code for the viewsthanks in advancesteve |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-27 : 12:41:37
|
| Yes SELECT access is just read-only access. The user will be unable to modify the view also as long as you haven't give the user other privileges such as db_owner role. Just give SELECT access only and that will do what you want.Tara |
 |
|
|
|
|
|
Access Rights