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 |
|
rlopez
Starting Member
18 Posts |
 Posted - 2006-08-24 : 13:17:45
|
| I would like to expose a series of views to some users from a database on my SQL 2005 server. I would like to expose the views with read only access and nothing else. What is the best way to accomplish this? If the SQL client is best way, how do I install it? I have the SQL Server 2005 installation DVD. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-24 : 13:22:34
|
| You would do this via management studioCreate a role in the database.Add the users to the role.Give read access to the views to the role.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rlopez
Starting Member
18 Posts |
Posted - 2006-08-24 : 13:29:47
|
| I guess the question I should have asked is: how do I install just the Management Studio on a client machine. I have been trying to use the SQL Server 2005 installation DVD, but have not had any success. |
|
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-08-25 : 13:00:46
|
| Why would you want to install Management Studio? Your front-end application should be displaying the data from the views.Ken |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-08-25 : 13:08:17
|
| If you just want to install the Management Studio from the DVD, start a normal installation and then during the instal, when prompted to select the components to install, only select Management Tools.But note that you do not need to install the Management Tools in order to connect to the server and use SQL Server from a user application. The client connectivity in the application (MDAC, the .NET SQL Client etc.) will do that. |
|
|
|
|
|
|
Exposing Read-Only Views