If the Query Privilege field in a Security User record is set to Unrestricted or the field is empty, no query options will behave differently. Instead, queries will behave as described elsewhere in the documentation.
Some query options will behave differently based on the query privilege setting in your Security User record (i.e., the value in the Query Privilege field). The following sections describe how the queries will behave when you are logged in as a Security User with any of these query privilege settings. These sections describe only the options that behave differently. You can assume that any option that is not mentioned here will behave as described elsewhere in the documentation.
If the Query Privilege field in a Security User record is set to Unrestricted or the field is empty, no query options will behave differently. Instead, queries will behave as described elsewhere in the documentation.
If the Query Privilege field in a Security User record is set to Restricted By Timeout Limit, the user will be able to create and modify existing queries; however, the user must run the query before saving. If a query timeout limit has been specified in the database and the query run exceeds that limit, the user will be unable to save the query.
If the Query Privilege field in a Security User record is set to Execute Only, the user will be able to view query results, but not create or modify queries. This means that these Security Users will be able to access the Results workspace, but not the Design or SQL workspace.
Specifically:
Copyright © 2018 General Electric Company. All rights reserved.