IBM i SQL Security for Database-driven Components

Owned by Rob Ferguson
Last updated: Aug 16, 2023 by Jessica Tomkins
1 min read



Various widgets, including auto-complete text boxes, database driven drop-downs, grids and charts use SQL to retrieve the required data from the database. This feature is configured through properties on the individual widgets. 

SQL statements for widgets run in a separate job from the Profound UI / Genie application itself, so QTEMP cannot be used with this feature. However, the library list and user profile of these separate jobs are synchronized with the Profound UI / Genie application session. The SQL queries will therefore resolve unqualified file references using the library list, and normal IBM i object authorities are in play.