370 reputation
211
bio website sqlserverupgrade.com
location Miami, FL
age 33
visits member for 3 years, 11 months
seen Dec 16 at 16:57

Database and Business Intelligence Practitioner


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