Skip to Content

Query Manager Autorisation

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 02, 2017 at 08:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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