Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
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
18:28, 13 Jul 2017

Tags

Classifications

Public