What privileges do I need in order to create queries?
The privileges described below are in addition to the privileges that are already set on the out-of-the-box Analyst role.
Modules | Metadata | Non-Process Related Objects
Metadata Catalog - Update
Module Block - Update
Query Aggregate Function - Create, Update
Query Attribute - Create, Update
Query Condition - Create, Update
Query Range Definition - Create, Update
Query Sort Attribute - Create, Update
Query Template - Create, Update
Configuration Components | Configuration | Designers
Query Builder - Execute
Create User Query - Execute
Create System Query - Execute*
* This privilege is only required if Users are required to create Queries available to all Users. If the privilege is not enabled the 'Everyone' option will not be available when the query is created.
To create a shortcut to the query when it is created:
Modules | User Interface | Non-Process Related Objects
Shortcut Item - Create, Update
Shortcut Group - Update
The above privileges are correct for Service Desk version 7.3.1 though should be very similar for earlier versions too.