Forum OpenACS Development: Re: Hierarchical query in Oracle - prvileges tree

I don't have OpenACS installed here so I can't test this, but would replacing the order by on the outer query with 'order siblings by privelege' (you might need to play around with what you are ordering by) on the inner query fix your problem?