Dear All,
We have a multiprovider and there are lot of queries on top of it. We need to restrict set of queries with set of people.
Ex: Query 1 to 10 -> Group A, Query 11 to 20 -> Group B, Query 21 to 30 -> Group c and so on.
I know that we can use multiple authorization objects and restict the users with those. But we want to restict the creation of multiple authorization objects hence i created a custom table and maintained user and authorized query and restrict the executing on the query at i_step 3 using "RRMS_MESSAGE_HANDLING" and this works perfectly fine for queries having selection screen or variables with user input but does not work for queries with no input variables(as the badi RRMS_MESSAGE_HANDLING throws error message and stops at variable screen, if there is no variable screen then the query executes along with the error message).
Is there any way we can achieve my requirement ? Thanking you all in advance.