Oracle Error Message
ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object
Reason for the Error
The user tried to grant SELECT privilege WITH HIERARCHY OPTION on an object that is not one of the following : object table of non final type, object view of non final type.
Solution
Ensure that the SELECT privilege WITH HIERARCHY OPTION is granted on a valid object.