Control metada visibility using few 'simple' statements

You may be aware that a user in a SQL Server 2005 database can only see metadata that the user either owns or on which the user has been granted some permission. A default policy enhanced as compared to how a DBA can control the security access to the database-table level. A better way to prevent unwanted users with minimal privileges from viewing other important data for all objects in that instance. GRANT VIEW DEFINITION TO public; This allows a override of view visibility at the database level,...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2007/08/09/1332.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1332" width="1" height="1">