Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30742: cannot grant SELECT privilege WITH HIERARCHY
OPTION on this object
- 1 Answers
- 5293 Views
- I also Faced
- E-Mail Answers
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 |
KUP-04074: no write access to directory object string
ORA-12527: TNS:listener: all instances are in restricted mode or blocking new connections
ORA-03001: unimplemented feature
ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option
TNS-12681: Login failed: the SecurID card does not have a pincode yet
PCC-02144: CMD-LINE: Blank characters are not allowed on either side of an equal sign (=)
ORA-07235: slemcw: fwrite error.
ORA-24786: separated transaction has been completed
ORA-39085: cannot update job string for user string
ORA-14163: subpartition number string: INITRANS value must be less than MAXTRANS value
ORA-01246: recovering files through TSPITR of tablespace string
ORA-09791: slembdf: translation error, unable to translate error file name.
Oracle Errors 
