Oracle database error code ORA-30741 – WITH HIERARCHY OPTION can be specified only for SELECT privilege

Oracle Database Error Code ORA-30741 Description :
WITH HIERARCHY OPTION can be specified only for SELECT privilege
Error Cause:
The user tried to specify WITH HIERARCHY OPTION for a privilege other than SELECT privilege.

How to Solve :
Ensure that the HIERARCHY OPTION is specified only with the SELECT privilege


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»