Oracle Error Message
ORA-30741: WITH HIERARCHY OPTION can be specified only for SELECT privilege
Reason for the Error
The user tried to specify WITH HIERARCHY OPTION for a privilege other than SELECT privilege.
Solution
Ensure that the HIERARCHY OPTION is specified only with the SELECT privilege