There are two levels of SQL reporting user in XLCubed, with differing levels of design access. This provides a controlled level of SQL reporting to non-technical users, giving access to SQL-based data without the risk of allowing free access to designing their own queries.
- Administrators: can create new connections and design new SQL queries from scratch using the Query designer. Administrator users can also publish pre-built queries to XLCubed Web Edition, for use by standard users.
- Standard Users: have no SQL designer access, but can use pre-published SQL queries from the SQL report library on XLCubed Web.