ORA-30742
Cannot grant SELECT or READ object privilege on a nonfinal object when WITH HIERARCHY OPTION is specified.
Cause
An attempt was made to grant the SELECT or READ object privilege when the WITH HIERARCHY OPTION was specified on an object that was not one of the following:
- a table or a view
- an object type on which the table had been created was of nonfinal type
Action
Ensure that the SELECT or READ object privilege is granted on a valid object when the WITH HIERARCHY OPTION is specified. Query ALL_OBJECTS to get the type of the object on which the privilege is being granted. Query ALL_TYPES to check if the object type used in the table is of final type.
ORA-30742
cannot grant SELECT or READ privilege when WITH HIERARCHY OPTION is specified on the object
Cause
An attempt was made to grant the SELECT or READ privilege when the WITH HIERARCHY OPTION was specified 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 or READ privilege is granted on a valid object when the WITH HIERARCHY OPTION is specified.
ORA-30742
cannot grant SELECT or READ privilege when WITH HIERARCHY OPTION is specified on the object
Cause
An attempt was made to grant the SELECT or READ privilege when the WITH HIERARCHY OPTION was specified 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 or READ privilege is granted on a valid object when the WITH HIERARCHY OPTION is specified.