Has anyone had the problem where iSeries Access For Web does not run some SQL features consistently?
I have a customer that is using this to provide reports from the iSeries to his customers. Customers can log onto the iSeries from the web and get to run reports already created.
The customer can run a request that either sends the output to an email with a PDF or XLS as an attachment. Also, other run requests are created, which send the PDF or XLS to the browser screen.
However, a request has been created (from the same SQL) that simply displays the output in the browser, but this errors stating that "the policy is restricted".
The customer access has been tightened down using the 'customise' option to restrict many policies. The only policies that the user sees are '5250' to start a pre-configured session from a shortcut and 'Database - My Requests' to run shortcut requests already created for them. The 'Run SQL statements' has been denied, but I don't this is the problem cause because the PDF and XLS output formats are displayed (the back end SQL logic is the same throughout).
The iSeries is at V5R4M0 (C8057540) with iSeries Access For Web V5R4 (SI31883 PTF); WAS 6.1 Express & IBM 32bit Java installed.
P.S. I have the policies file available if anyone wants to see it.
October 2, 2008 8:21 AM
October 3, 2008 9:33 AM