Reputation
390
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 11
Impact
~16k people reached

  • 0 posts edited
  • 0 helpful flags
  • 17 votes cast
Feb
21
awarded  Editor
Feb
21
comment The SELECT permission was denied on the (View) object after explicit grant select on view to user
@Marian - I have edited the code above to correct the doubling. That was a typo.
Feb
21
revised The SELECT permission was denied on the (View) object after explicit grant select on view to user
corrected doubling of where criteria; edited body
Feb
20
awarded  Teacher
Feb
18
answered The SELECT permission was denied on the (View) object after explicit grant select on view to user
Feb
18
comment The SELECT permission was denied on the (View) object after explicit grant select on view to user
I also verified in the sys.database_permissions and the 'appuser' is configured correctly to have select permission on the view.
Feb
18
comment The SELECT permission was denied on the (View) object after explicit grant select on view to user
Thanks for the name check... I had done a replace on the actual object name. its prefixed with an alpha.
Feb
18
awarded  Student
Feb
18
asked The SELECT permission was denied on the (View) object after explicit grant select on view to user