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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/