Hi,

I wish to control the authorization for user executing query i created (I mean i may just allow user1 to execute queryA, and another user2 to execute queryB and queryC). I can't find that the authorization can be set for a specific query. Is the system has that ability?

Beside, can the "Find" button in Execute Query session (ttadv3280m000) be removed (refer to attachment) ? Please guilde on how to do it?

Thanks.

I don't think you can do that. I believe you could create a session and run that query from the new session. Then you could give permission to the sessions in question.

For sure this can be done, at least I did it a couple of times in Baan5c.

You need to setup data authorisation for the query table like you can do for any table. Remove authorisation in the base authorisation, add new roles in which you define the right queries.

Removing the find is not possible, we can't modify tools sessions.

Regards,
Han

Thanks for sharing your expertise. I get the idea.