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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2008-01-24 : 00:45:09
|
| Hi thereIf I give the user access dbo on 1 of the database, when he logon using SQL Server Management Studio for running query etc, can he only see his database instead of other as well system database?Is there any best practise in term of setting the SQL client for 2005?Thanks |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-24 : 04:33:26
|
| no, that user can see the names of all databases on your server. this user can only access data in the system databases (master, msdb, model, tempdb) and the databases you have explicitely granted access to (granted dbo privs in your example).but this user will be able to see the names of the other databases in your environment. usually this is not a problem. In sql 2005 there is the ability to disable someone seeing databases that they do not have access to. -ec |
 |
|
|
dewacorp.alliances
452 Posts |
Posted - 2008-01-24 : 13:11:28
|
quote:
In sql 2005 there is the ability to disable someone seeing databases that they do not have access to.
I've tried to find this info. Anyone know this? |
|
|
|
|
|
|
SQL Server 2005 Client Access