Error, "ORA-00942: Table or View does not exist" when trying to connect (4226106)

Error, "ORA-00942: Table or View does not exist" when trying to connect

When trying to connect to a particular schema on an Oracle database the following error occurs:

ORA-00942: Table or View does not exist

Other schemas including SYSTEM can connect just fine.

The particular schema did not have privileges to SYS views.

Grant privileges necessary to the user schema to access SYS views.

NOTE: Compare user schema's privileges that can connect to the schema where the error occurs to match privileges.

While connecting SQL Monitor shows the following query is sent to Oracle, test the query below and check if the schema can run it outside of Toad (SQL Plus)

select object_name nam, Decode(object_type, 'TABLE', 1, 'VIEW', 2, 3) typ
from user_objects
where object_type in ('TABLE','PROCEDURE', 'PACKAGE', 'FUNCTION')

If the same error occurs outside of Toad, then there are missing privileges required to connect.

This message can also appear silently, when it relates to Toad Security. It doesn't appear as an error in the application, but it does show in the logs during connection. If the connecting user is not a DBA user, Toad runs this query to determine if Toad security is in place. For this purpose, a user is considered a “DBA” if connected as SYSBA, or if the user has both ALTER SESSION and ALTER DATABASE privilege. Older versions of Toad checked for the DBA role, but we don’t do that anymore. There is no way to disable the check for Toad security.