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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100

1 Answers  


ORA-16162: Cannot add new standby databases to protected configuration

1 Answers  


ORA-01466: unable to read data - table definition has changed

1 Answers  


ORA-21613: key does not exist

1 Answers  


ORA-29342: user string does not exist in the database

1 Answers  






ORA-09203: sfofi: error opening file

1 Answers  


ORA-13337: failure in concatenating LRS polygons

1 Answers  


NNL-01064: Statistic counter reset interval: string

1 Answers  


ORA-23438: missing refresh group template

1 Answers  


RMAN-06131: skip offline/readonly only allowed with current controlfile

1 Answers  


NID-00311: Control File string - modified

1 Answers  


ORA-03205: partition name is required when partitioned type is specified

1 Answers  


Categories