Network Management

Required permissions to execute SWQL and SQL queries for web-based reports

This article explains the security permissions required to execute SWQL and SQL queries for web-based reports.

First published date

10/30/2018 7:06 PM

Last published date

2/4/2020 8:28 PM

Overview

Creating SQL reports in Orion needs Administrator permissions for security reasons.

Product section

Network Performance Monitor

Cause

Data may contains sensitive information, and restriction on SQL based reports is by design.

Resolution

Report is SQL transaction/commands which used to query for the needed data from certain column within specific table(s) in the database.

Running a query (SQL-based report) requires both administrator and report management permissions for security reasons. SQL queries can alter and potentially corrupt a database, therefore, these queries are restricted to administrators only. Without this permission, the option to build/create report(s) will be limited.

SWQL-based reports are still available as they use basic SQL style commands to select data and do not allow the user to alter data which makes it a non-security risk compared to SQL.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.