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 |
|
pramod21
Yak Posting Veteran
64 Posts |
 Posted - 2011-02-17 : 01:24:18
|
| HI,I have one odbc server in netwok.for everyone login and the pwd is same.in that server so many databse are there.i want to make one databse as read only for couple of user and rest of them have read write permission.plz tell me how to that? |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-02-17 : 03:46:38
|
| Set db_datadenywriter role for those users whom you want to have read only permissions.PBUH |
 |
|
|
|
|
|
probiding read only access for db in network