SELECT Permission Error on base table when using a VIEW

alcjk — Thu, 20 Jan 2011 18:42:02 GMT

I have an Infopath 2007 form that does a simple query and submit to a SQL Server 2005 View. The view does a SELECT on the Table (there are no joins) with a WHERE clause to filter the Rows. When I click the SUBMIT button, I get an error saying that I don't have SELECT permission on the base table the view is referencing. The user id has Select and Update permission on the view (I've tested and confirmed that outside of InfoPath). Also, if I grant Select permission to the base table, then the InfoPath submit will work (not an option for deployment). As far I can see, the InfoPath form never references the base table name at all. I'm stumped. Any clues? Thanks much:

Error I am getting:

InfoPath cannot submit the form.
An error occurred while the form was being submitted.
The SELECT permission was denied on the object 'MyBaseTableName', database 'MyDataBaseName', schema 'dbo'.

SQL Database Integration

SELECT Permission Error on base table when using a VIEW