· To avoid non-Admin (other than Administrators profile) users from running and editing the SQL Based Reports to retrieve information beyond their access policies, unselect the ‘Allow execution of SQL-based reports’ option in Users > Profiles > Add Profile/Edit Profile > Modules > Report Manager.
· SQL-based reports can also be invoked from the Global I/O module through event or periodic trigger.
· Default sanity report returns unprivileged data.
· Contact the Support Team for any high-level ERD of database/assistance in writing complex SQL-based queries to meet individual requirements.
See also:
Object SQL-based Report Template