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 |
|
mshsilver
Posting Yak Master
112 Posts |
 Posted - 2010-07-22 : 05:11:34
|
| Hi,I am a SQL administrator and have full access to a 2005 SQL server. I have created a new user that I want to be able to access there database and only their database via, Management Studio Express and their own connection strings for their code.I have managed to give them access through Management Studio Express but they can see all our other databases too, they do not have permission to access them but they can see them and other user accounts.I found this below but it removes access to all the databases so they can't see theirs. Any help on this would be great. Thanksuse masterRevoke View any database from publicgo |
|
|
kfluffie
Posting Yak Master
103 Posts |
Posted - 2010-07-24 : 03:22:57
|
| Hi,I have tried to fix this problem before and have googled a bit and it seems to be a problem within MSSQL that you just can't grant view to one database.When you process "DENY VIEW ANY DATABASE TO <user>" to the _login_ it is very high up in the "permissional ladder" and the only way to be able to be able for the login to see the your (one I guess) database is to make the login the db_owner:* Right click on the DB and choose Properties -> Files and change the "Owner" to your login.Interesting reading:http://technet.microsoft.com/en-us/library/ms186308.aspxhttp://www.sqlservercentral.com/Forums/Topic860560-359-1.aspxBest regards,KFluffie |
 |
|
|
|
|
|
User access