ORA-30741: WITH HIERARCHY OPTION can be specified only for SELECT privilege
What triggered the Error:
The user tried to specify WITH HIERARCHY OPTION for a privilege other than SELECT privilege.What should we do to fix it:
Ensure that the HIERARCHY OPTION is specified only with the SELECT privilege