ORA-00942 when generating pl/doc without DBA permissions (1.5.17)
Status: Alpha
Brought to you by:
altumano
Menu
▾
▴
#108 ORA-00942 when generating pl/doc without DBA permissions (1.5.17)
Hello,
the application retuns a java.sql.SQLSyntaxErrorException in my environment.
The problem appears to be the query defined by statement "synonymStatement" in PlDoc class (extractSynonyms method).
Without having access to the dba_synonyms table the application produces the following exception:
ORA-00942: table or view does not exist.
I tried to substitute the dba_synonyms with all_synonyms and everything works as espected.
I'm using java 7 and oracle 12.
Thank you for your great product!
Hi, I like this software, but I've the same problem.
In the class PLDoc at line 241 the statement "synonymStatement" contains a "FROM dba_synonyms" but when it's executed, there's not a "Revert to ALL_OBJECTS" trick like done at line 430 for the statement that use " dba_objects".
I've solved with a workaround, by making a copy-and-paste of the class and changing the "dba_synonyms" in "all_synonyms". :P
Thanks!