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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Hiding SQL Server Databases

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-11-16 : 17:48:42
John writes "I am at a loss for a way to hide the existence of a database in SQL server from a specific user. It is straightforward enough to disallow access to one database or another for a user, but even without rights to a particular database, the user can still see that it is there and the name of it (in enterprise manager), but they just can't get at it. This seems like a big potential security threat if you were hosting multiple databases for multiple clients and didn't want them poaching on each other's stuff or even being aware of who else's database you are hosting. Is there any way to hide databases from a user that they don't have access to?"
   

- Advertisement -