ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object

ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object

Cause: 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.

Action: Ensure that the SELECT privilege WITH HIERARCHY OPTION is granted on a valid object.