SQL Administrators are responsible for creating connections and queries for all relational reporting in the organisation. These connections and queries can then be distributed to Standard SQL Users in one of two ways:
- Distribution of workbooks
- Publication of queries using XLCubed Web Edition (see this article for more detailed instructions)
Once distributed either in workbook form or via XLCubed Web Edition, the connections and queries become read-only to standard users, though any parameters provided in the query will still be editable. SQL Administrators will continue to be able to modify the queries.