SQL Server Management Studio - Limiting views on shared servers

re: SQL Server Management Studio - Limiting views on shared servers

Michael — Sun, 17 Jun 2007 13:02:33 GMT

Grant View any database to public

re: SQL Server Management Studio - Limiting views on shared servers

sam — Tue, 08 May 2007 07:15:26 GMT

used the following command on our shared sql server

use master

Revoke View any database from public

After that we are not able to see our database from the client PC so can we revert back this command to as it is or any command which change dbo permission on the database because we don;t want use following command manully for all database

EXEC sp_changedbowner

re: SQL Server Management Studio - Limiting views on shared servers

HosterPoster — Wed, 27 Sep 2006 17:41:05 GMT

This is a good question and we are checking it out...

Very nice blog entry!

Mathew Ford — Fri, 21 Apr 2006 09:06:00 GMT

Wow...great info on locking this down! Thanks for that.
Is there any way to give a server login the ability to see multiple databases if they aren't technically the owner of the database (but part of the dbo role for example)? It seems that this "fix" would prevent access to any other database from SSMS, even if the user had permissions in it.