Submit a ticketCall us

WebinarUpcoming Webinar: Easily Automate Backups and Simplify Log Message Management

Backing up your network configuration and logging data are a few steps to helping keep your network safe. In this in-depth webinar, we’ll show you how these tasks can be automated to save your IT team time while maintaining accurate archives of your data.

Register now.

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