USER_DIM_HIERARCHIES describes the dimension hierarchies owned by the current user. Its columns are the same as those in ALL_DIM_HIERARCHIES.