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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-10-10 : 00:37:18
|
| GurusI want to give the users only select priviliges on the DB.What command i will use?RegardsNitin |
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-10-10 : 00:51:53
|
| You can give the user access to datareader access. |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-10 : 01:22:15
|
| the easiest way to do this would be to use Enterprise manager and grant the datareader role to the user login (as valdyv suggested).you can also do the same via the sp_addrolemember system stored procedure. More info on this is in BOL (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_90f9.asp)-ec |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-10-10 : 05:09:51
|
| Thanks a tonRegardsNitin |
|
|
|
|
|
|
Select rights on the DB