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 |
|
velliraj
Yak Posting Veteran
59 Posts |
 Posted - 2008-07-21 : 03:32:33
|
| Hi I need to provide read acess to my data base to the other users acessing my db.Please let me know how to do it. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-21 : 03:39:50
|
Give them DATA_READER access only.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
velliraj
Yak Posting Veteran
59 Posts |
Posted - 2008-07-21 : 03:42:54
|
| do i need to specify any user name or excuting this query will do the enough job? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-21 : 03:52:58
|
Yes. You have to select a database user for the database and give only DATA_READER access.Then all end users you want to only read should login with usernamd and password for database user mentionend above.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
velliraj
Yak Posting Veteran
59 Posts |
Posted - 2008-07-21 : 05:43:02
|
| Hi Thanks a lot it's working, but a small doubt, no sp's list are displaying.is it possible they can view the sp's list and with read acess. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-21 : 05:45:37
|
You can give them EXECUTE access to the SP you want.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
velliraj
Yak Posting Veteran
59 Posts |
Posted - 2008-07-21 : 07:51:32
|
| hi,please tell me how to give exec permission to sps.Is there anyrthing to do with settingsplease do the needful |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-21 : 21:59:23
|
| grant exec on sp_name to ..., books online has syntax and samples. |
|
|
|
velliraj
Yak Posting Veteran
59 Posts |
Posted - 2008-07-22 : 08:08:52
|
| Hi, thank u very much. |
|
|
|
|
|
|
Read acess to DB