Permissions required for row counts to show up on Object Explorer Details

Leave a comment

January 16, 2020 by Kenneth Fisher

I ran into a rather obscure permissions problem the other day. Since I wasn’t able to figure it out on my own I posted for help. This wasn’t something I felt could be easily translated into #sqlhelp so I went ahead and posted it on Stack Exchange then tweeted the link, with a brief description, on #sqlhelp.

Basically I needed to know what permissions were required to see the row counts in the Object Explorer Details tab. Yes, I’m aware of a number of different ways to get the row count of a table, however this was a client request and they specifically wanted to use the OE Details tab.

And simply enough the answer was VIEW DATABASE STATE. In hindsight this makes some sense as this permission gives you access to a number of DMVs (Database Management Views) that even read access at the database level doesn’t.

Thanks Ernest Libertucci (twitter)! I really appreciate the help!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: