0

I've a db called "abc" against login "cde". When i access this db remotely MSSQL Server 2005 shows me all the databases however User "cde" can only access db "abc". How can i disable view of all database?

User4283
  • 781
  • 3
  • 10
  • 27

1 Answers1

1

You need to remove the rights for the guest user in all the databases.

This typically isn't needed as it isn't usually a security problem to allow users to simply see what databases exist on a server. Just because they can see them doesn't mean that they have access to them.

mrdenny
  • 27,174
  • 4
  • 41
  • 69
  • Can you please let me a little brief me where would i remove guest rights? because i've created a test database and guest user does not have access of it. Still when i connect to test database it shows me all the databases. – User4283 Aug 17 '11 at 16:59
  • It's been a while since I needed to do this. In newer versions you'll probably need to delete the guest user from the databases. Again this isn't recommended and it is not a security issue for users to see databases which they can not access. – mrdenny Aug 17 '11 at 19:47