My Oracle Support Banner

EM Grid Tables Link Gives Java.Sql.Sqlsyntaxerrorexception:ORA-00942: Table Or View Does Not Exist (Doc ID 1322943.1)

Last updated on DECEMBER 22, 2019

Applies to:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.

NOTE: In the images and/or the document content below, the user information and environment data used
represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered
with an Oracle database product or other training material. Any similarity to actual environments,
actual persons, living or dead, is purely coincidental and not intended in any manner.


Customer is trying to create a read-only user for monitoring purposes and to connect to Enterprise Manager.

Newly created user gets Java.sql.SQLSyntaxErrorException:ORA-00942: table or view does not exist in Enterprise Manager -> Database -> Schema tab -> tables link

1) Create user user1 in Grid Control with monitor only privileges
2) Create user user1 on target database test1 to have read only privileges on scott.emp table
3) Log into Grid Control as user1 and then log into target database server as test1 user (tried to work with schema tab to see if I can see all data from scott.emp table - this did not work, also tried to execute a query from sql work sheet - select * from scott.emp - this did not work either)
4) Getting Error - Java.sql.SQLSyntaxErrorException:ORA-00942: table or view does not exist
5) On target server TEST1 database I can login as user1 and run a query select * from scott.emp - I get all my results on database level on the server
6) Through 'Execute SQL' sheet, able to see the results for 'select * from scott.emp'.
7) Create a new table in 'USER1' user and still not able to see through 'Schema' tab in Grid Control


User is newly created with CONNECT, RESOURCE role at the database level.
Also proper select on the tables is already given like GRANT SELECT ON SCOTT.EMP TO USER1


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.