| Author |
Topic |
|
henrikop
Constraint Violating Yak Guru
280 Posts |
 Posted - 2008-03-20 : 10:19:02
|
| I have a database user with rights on one database. If he connects with management studio 2005 he can see all databases.How to change that he can only see database where he has rights on viewing and/or changing?Henri~~~~There's no place like 127.0.0.1 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-20 : 10:23:46
|
| look into db permissions for the user or group in which he's a member |
 |
|
|
henrikop
Constraint Violating Yak Guru
280 Posts |
Posted - 2008-03-20 : 10:58:24
|
| I have no clue where to start. I just have one user which is a dbo of one database. I do not want him to see the other databases other than the one he is owner of. Could you give me some more direction?Henri~~~~There's no place like 127.0.0.1 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-20 : 11:05:01
|
| Goto logins:-choose that user-See what database he has access to.See if he is owner of other databases as well. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 18:10:50
|
| DOn't think you can do that. User can't access db without permission anyway. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-21 : 18:42:38
|
| There is no way to prevent this. The user will be able to see the databases but will only be able to access the one where he/she has permissions to it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2008-03-23 : 23:47:56
|
| check if he has public roll assigned. then he can view all the databases but can access only the one to which he has privilege. try to remove the public roll and then check |
|
|
|
henrikop
Constraint Violating Yak Guru
280 Posts |
Posted - 2008-03-24 : 11:45:43
|
| Gone for easter.He is DB owner of one database. No rights or roles besides it. That does not give him a public role, does it?I know Tara is right when it comes to sql 2000, but 2005 might be changed.Henri~~~~There's no place like 127.0.0.1 |
|
|
|
prateja
Starting Member
2 Posts |
Posted - 2008-03-24 : 18:19:38
|
| Remove Guest user account from all databases this will prevent users with public role on viewing databases. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-24 : 22:46:50
|
| You can't delete guest user in sql2k5, and it's disabled by default. |
|
|
|
|
User can see all databases SQL 2005