I have a database with a View Named '1098Statement' We are doing testing for an application with user name 'appuser'.
I have tried the following solutions to granting select on the view and keep getting error:
- Grant Select on View
- Add user to db_datareader
Add user to a database role which has select granted on the view
Msg 229, Level 14, State 5, Line 2 The SELECT permission was denied on the object '1098Statement', database 'mydb', schema 'dbo'.
None of them work.
Are there any pointers anyone can provide on troubleshooting this issue.
My only remaining thoughts are to check
- the user account to see if there are any explicit "deny" restrictions on either the user or any roles the account belongs to.
- check the view to see if there are any explicit deny