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 |
|
vpspatrick
Starting Member
5 Posts |
 Posted - 2010-02-20 : 04:44:02
|
| Hello All,I have installed a MsSQL 2008 on my dedicated server which is used by all my client who are hosting there site on the server.Now the problem is that any MsSQL user when logged in to MsSQl can view the database of other clients.What I want to do is to restict each user to view only his associated database.Please let us know how to do that.Awaiting for responsePatrick |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-20 : 04:52:34
|
| Do NOT give the server login server roles - such as SysAdmin (SysAdmin can see everything)Set default database for the server login - so when they login they go straight to their own database (not a requirement, just a "nice-ity")Even so the users will (probably?) be able to see the names of other databases, just not able to access them - is that good enough? |
 |
|
|
vpspatrick
Starting Member
5 Posts |
Posted - 2010-02-23 : 02:10:39
|
| Hello Kristen,Under the server role for user "chichakshop" I have only ticked "public" and all other are not selected.Then also when logged in with user "chichakshop" I can view all the data bases..Awaiting for responsePatrick |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-23 : 02:44:34
|
| You can see the names of the databases? or you can select data from them? |
|
|
|
vpspatrick
Starting Member
5 Posts |
Posted - 2010-02-23 : 03:08:12
|
| Hello,Am able to view them as well as the extract the dataAwaiting for response.Thanking you in advance...Patrick |
|
|
|
vpspatrick
Starting Member
5 Posts |
Posted - 2010-02-23 : 03:31:39
|
| Hello,Have checked the other MsSQL server that we are having and found that we are facing the same error on the other server too.Awaiting for prompt reply.Pat |
|
|
|
vpspatrick
Starting Member
5 Posts |
Posted - 2010-02-25 : 02:06:47
|
| Hello All,found the solution, have only selected the public option under "server role" for the database(so that we can restrict it access)and have allocated some permission of sa to public :)Patrick |
|
|
|
|
|
|
SQL 2008 user problem