patternsqlModerate
Permissions required for row counts to show up on Object Explorer Details
Viewed 0 times
showpermissionsexplorerobjectfordetailsrowcountsrequired
Problem
I'm having a weird security issue. I have a user that's using SSMS 18.2 on a SQL 2016 server. They are a member of db_datareader but when they pull up the the Row Count column in Object Explorer Details it's blank. As best I can tell it is requiring DBO in order to get the row counts to show up.
User with read access:
User with dbo access:
Is this a bug or intentional? Does anyone know if there is a lower level of permissions that will give this row count? I know there are plenty of other ways to get the row count, sys.partitions for example, however the user insists they want to use the OED window.
User with read access:
User with dbo access:
Is this a bug or intentional? Does anyone know if there is a lower level of permissions that will give this row count? I know there are plenty of other ways to get the row count, sys.partitions for example, however the user insists they want to use the OED window.
Solution
Through a little experimentation, I discovered that rowcount requires "VIEW DATABASE STATE".
Methodology: Captured queries that SSMS runs and executed as a user with datareader permissions only. One in particular throws an error. After granting the permission, verified that rowcounts were now visible.
Methodology: Captured queries that SSMS runs and executed as a user with datareader permissions only. One in particular throws an error. After granting the permission, verified that rowcounts were now visible.
Context
StackExchange Database Administrators Q#256550, answer score: 11
Revisions (0)
No revisions yet.