SQL Server Performance

Control metada visibility using few 'simple' statements

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 9, 2007.

  1. Anonymous New Member

    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">

Share This Page