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

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.