https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/37811.aspxThu, 29 Jan 2009 02:27:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:37811Shiva0https://www.infopathdev.com:443/forums/thread/37811.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=37811<p>Hello,</p> <p>In your case you have to prepare one secondary xml file which contains two groups and in that list you have to add the list to submit and editing permission users. In onLoad code, you have to verify the login user is available in edit permission is there or not for submitted form and check the login user is available in submit permission for new form. Based on this we can open the form otherwise we can close the form with message prompt.</p> <p>Your secondary xml file should be;</p> <p>&lt;Permissions&gt;</p> <p>&lt;Group name=&#39;Submit&#39;&gt;</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;User&gt;aaa&lt;/User&gt;</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;User&gt;bbb&lt;/User&gt;</p> <p>&lt;/Group&gt;</p> <p>&lt;Group name=&#39;Edit&#39;&gt;</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;User&gt;ccc&lt;/User&gt;</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;User&gt;ddd&lt;/User&gt;</p> <p>&lt;/Group&gt;</p> <p>&lt;/Permissions&gt;</p> <p>Another way is you use User Roles in InfoPath forms.</p>https://www.infopathdev.com:443/forums/thread/37791.aspxWed, 28 Jan 2009 17:12:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:37791geoffc0https://www.infopathdev.com:443/forums/thread/37791.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=37791Is it possible to implement sql server application roles to my infopath form? the idea is to allow the form to submit/update the data but not the individual users. Thank you.