Oracle Solution for Error ora-30741
ORA-30741: WITH HIERARCHY OPTION can be specified only for SELECT privilege
What triggered the Error:
The user tried to specify WITH HIERARCHY OPTION for a privilege other than SELECT privilege.What should we do to fix it:
Ensure that the HIERARCHY OPTION is specified only with the SELECT privilege
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
