USER_HIERARCHIES describes the hierarchies owned by the current user. Its columns (except for OWNER) are the same as those in ALL_HIERARCHIES.