I am getting the error "ORA-00942: table or view does not exist" when doing an Object Search.
In Toad 9.6.1 the Object Search requires privileges to access more tables.
SOLUTION #1:
Make sure that 'Check for access to DBA views' is checked. This option can be found by going to View | Toad Options | Startup.
SOLUTION #2:
Make sure the user has access privileges to the following tables.
FROM SYS.DBA_OBJECTS
FROM SYS.DBA_SNAPSHOT_LOGS
FROM SYS.DBA_CONSTRAINTS
FROM SYS.DBA_ROLES
FROM SYS.DBA_JOBS
FROM SYS.DBA_TABLESPACES
FROM SYS.DBA_USERS
FROM SYS.system_privilege_map
FROM SYS.DBA_REFRESH
FROM SYS.DBA_QUEUE_TABLES
FROM SYS.DBA_PROFILES
FROM SYS.DBA_POLICIES
FROM SYS.DBA_POLICY_GROUPS
FROM SYS.DBA_TAB_COLUMNS
FROM SYS.DBA_TRIGGER_COLS
FROM SYS.DBA_IND_COLUMNS
FROM SYS.DBA_CONS_COLUMNS
FROM SYS.DBA_SOURCE
FROM SYS.DBA_VIEWS
FROM SYS.ALL_JOBS
