The 'View SQL' button (when enabled) is only available for admin roles in Ad Hoc Designer. Other users should have this functionality too: since user has access to the designer and can create Views and Reports, he/she might also need to see the generated query.
Alternative solution: make the visibility of the 'View SQL' button configurable. At the moment it is possible to make the button visible by customizing the adHocDesigner.jsp file, but there is no query displayed for non-admin users.
Stas Polivyanenko
| Components | AdHoc |
