Well I'd like to display the tree the way it is, not orderd by levels. This modification returns:
TREE_LEVEL PRIVILEGE CHILD_PRIVILEGE
---------- -------------------- --------------------
0 another_top_level
0 one_top_level
1 one_top_level sub_level
2 sub_level sub_sub_level
but the two first lines are not determined by the hierarchy but by hte alphabetical ordering of their names, e.g. if the parent of 'sub_level' was 'another_top_level', it would still appear on that position which is wrong.
