Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Required permissions to execute SWQL and SQL queries for web-based reports

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

Table of contents

Updated July 14, 2017

Overview

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

Environment

All NPM versions

Detail

Creating an 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 an SQL query is grayed out. 

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

 

Last modified

Tags

Classifications

Public