SQL Server 2012 CU2: New permissions for DBCC SHOW_STATISTICS.

Cumulative update #2 is now available for SQL Server 2012, and I’m happy to let you know that there is a very, very welcome change in database user rights.

If you have SELECT permissions on a given table, you can now execute DBCC SHOW_STATISTICS to view the statistics histogram of any stats object on that table. Yep, this also means you get to see the histogram in Management Studio as well. Very cool. You no longer need to be a member of db_ddladmin or higher.

To disable this new behavior, enable trace flag 9485. For more details, see KB 2683304.