When attempting to produce a script for a User in Schema Browser, the following error occurs.
"Error: ORA-00942: table or view does not exist"
This error is due to the fact that we do not have Java Objects in our database. Solution SOL4825 suggests unchecking 'Grants to the User' in the Users tab of the Script Options, but this also ignores specfic Object Grants to the user. Requesting an option to ignore the Java Policy grants only.
Enhancement request ST68109 has been submitted to Development for consideration in a future release of Toad for Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center