SELECT Permission Error on base table when using a VIEW - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

SELECT Permission Error on base table when using a VIEW

Last post 01-20-2011 10:42 AM by alcjk. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 01-20-2011 10:42 AM

    • alcjk
    • Not Ranked
    • Joined on 01-20-2011
    • Posts 1

    SELECT Permission Error on base table when using a VIEW

    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'.

Page 1 of 1 (1 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.