| Author |
Topic |
|
tftr_si
Starting Member
6 Posts |
 Posted - 2008-03-31 : 11:13:07
|
| Hi guys,I want to give someone read only permission to our SQL server so they can log in and look at the database structure and query a few tables. I've set up the user but the problem is that when I connect in SQL server remotley, it shows all the other DB's on the server even though it is restricting access to them. Can these other DB's be hidden so that only the DB the user has access to shows up? Cheers for your help! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 11:15:03
|
| Just give DB-Reader Permission to only database that they need. |
 |
|
|
tftr_si
Starting Member
6 Posts |
Posted - 2008-03-31 : 11:18:53
|
| yea, i've got the read only bit of it working but I don't want the user to be able to see the other names of databases on the server, only the one they have access to (when they log in remotley in Enterprise Manager)It's SQL 2005 by the way. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 11:25:38
|
| Yes ,they won't be able to see if you restrict that databases. |
|
|
|
tftr_si
Starting Member
6 Posts |
Posted - 2008-03-31 : 11:34:05
|
| I have. The user is a 'db_datareader' with connect and select permissions only. When I connect remotley in Management Studio, I can see all the other DB's on the server in the list (even though I don't have any access rights to them). |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 11:38:46
|
| Did you connect using their Username and Password? |
|
|
|
tftr_si
Starting Member
6 Posts |
Posted - 2008-03-31 : 11:42:33
|
| yea |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 11:45:19
|
| Yes they will see but they won't be able to access.It will say:'Database unaccessible' |
|
|
|
tftr_si
Starting Member
6 Posts |
Posted - 2008-03-31 : 11:47:09
|
| So, re: my original question - there's no way around that then?? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-31 : 22:21:16
|
| Don't think so. |
|
|
|
|
Read Only Access / DB List in Enterprise Manager