Thanks for the replay, script-base solution looks like a good idea. Where can I find good examples on how to changes Analysis ( thanks for the clarification ) permissions using a script? 

1. We don't use BI publisher 2. All reports are stored in web catalog under folders, it can be that the reports which are requested by a customer are located in different folders. need some out of the box solution

There is no "read-my-mind" coding - it's a simple code ... can you make it work using a direct query?

ok, thanks, I understand your point very clear but you need to understand also that there is no other possibility ( it was explained to the customer but still this is what the customer wants) If there is no solution using direct query you can just say it, you don't need to tell me about what is good or bad, and what is the…

please see my post below

"Honestly, your query looks like a workaround for something " - I can't publish the real query, I used this simple query to point out the problem. How is the list of 1000 values selected? - using "Where in" clause will return with the following error ORA-01795: maximum number of expressions in a list is 1000 error "I'm…

1. same error in the database 2. I know what the error means I'm looking for a solution using direct query in OBIEE