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:

WordPress.com Logo

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

Google photo

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

Twitter picture

You are commenting using your Twitter 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,099 other followers

Follow me on Twitter

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