Authorization for query.

[Former Member]

Dear Sir

I have many User Define Query But I don't want to show all query to User How I set

the Authorization for query as per User wise.

Regards

Manegsh Pagdhare.

[former_member583013 · Accepted solution]

In the query manager window, you can see a button for Manage Categories

You will need to define categories for each user group.

Then, in the Authorizations window > Reports > Query Generator > Saved Queries - Group No. x

Assign the group to the user - the reports within the group are available for the users

[Former Member · Accepted solution]

Dear Expert,

Assign the group to the user - the reports within the group are available for the users

how i do this i create a group but i not know

how the assign the groups to user for authorization..

Please tell me path to do this....

Regards

Mangesh Pagdhare.

[former_member583013 · Accepted solution]

You do not have to create the group. Did you go to the Query Manager window and on the top you should see Manage Categories. Click that and you should see the groups.

how the assign the groups to user for authorization..?

.............Please read my previous reply...I have given the path.

[Former Member · Accepted solution]

Very Very Thanks

[keith_taylor2 · Accepted solution]

We have a standard methodology of doing this for all clients. First we pre-set and create sub menus such as the following:

Administration(15)

Inventory(14)

Customer Service(13)

Accounts receivable(12)

Accounts Payable(11)

Formatted searches(1)

etc

Keep a separate menu option for things like formatted searches where you want all users to be able to access them and check all boxes by groups

The numbers in the parenthesis refer to the group number. You only check the group number that applies to the sub menu then in authorizations you give users access to the groups that you want them to see reports for. You will note that in authorizations there are 20 groups but only 15 are used so far.

This has been very useful for us.