Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Network Performance Monitor (NPM) > 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