Windows user has SELECT and DB_DATAREADER writes still gets: "The SELECT permission was denied on the object"

Question

Windows user has SELECT and DB_DATAREADER writes still gets: "The SELECT permission was denied on the object"

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Maxer SSCrazy Eights Points: 8964 More actions · Answer 1

Jeff Moden - Tuesday, October 2, 2018 8:27 AM
Maxer - Tuesday, October 2, 2018 8:22 AM
OK this is more strange:
We took a NEW user, should be the same as the current one...he can query everything just fine... without any issues.
Is there a way I can compare two windows accounts to see why one is different than the other with privs?
Was the original user part of an AD group where the AD group was denied privs?

That was it, there was an OLD OLD OLD orphaned group that was in the denyreader... wow.

Thank you!