Return
-
Title
Scripts/Job Monitor not Working -
Description
When trying to open the scripts/job monitor window, we get an error message that a table or view is missing (ORA-00942). Getting the same error (ORA-00942) when trying to use the script/jobs monitor -
Cause
permissions -
Resolution
Exit out of SpaceManager
Using sqlplus connect as sys to database
Grant select sys.v_$instance to QUEST_REORG;
Login to SpaceManager and see if it worksAnd if that did not work:
Exit out of SpaceManager
Using sqlplus connect as sys to database
Grant select any dictionary to QUEST_REORG;
Login to SpaceManager and see if it worksIf that doesn't help then grant select_catalog_role to QUEST_REORG