Skip to Content
0

Query Manager Autorisation

Oct 01, 2017 at 12:32 AM

56

avatar image

How to define authorisation for a user to have access in read only for the queries in the Query Manager (managed/not managed by category), and not allowing editing neither deleting the query.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Johan Hakkesteegt Oct 02, 2017 at 08:54 AM
0

Hi,

  1. Please go to: Administration > System Initialization > General Authorizations.
  2. Select the user on the left side of the form.
  3. In the Subject column go to: Reports > Query Generator.
  4. Set to No Authorization: Create/Edit Categories
  5. Set to No Authorization: Execute Non-select SQL Statement
  6. Set to No Authorization: Modify SQL Statement
  7. Optional: Set to No Authorization: New Queries

Regards,

Johan

Show 2 Share
10 |10000 characters needed characters left characters exceeded

I configured exactly the same settings. The only concern is how the user can execute or run the query.

The only way it can be executed is via saving the query in the My Menu per user.

I am still searching for an alternative.

Thanks!

0

Hi,

With these settings the user can see and execute all queries in the normal menu (Tools > Queries > User Queries), but they cannot alter any queries or categories.

If you want to limit the user to be able to only execute certain queries, you can do so by managing authorization groups in the Query Manager (Tools > Queries > Query Manager...). The user can then be given or denied rights to the selected Authorization Group (Administration > System Initialization > Authorizations > General Authorizations > Reports > Query Generator > Saved Queries - Group No. x)

Regards,

Johan

0