Return
-
Title
Can not view schema browser data grid for SYS schema objects, error ORA-00942 -
Description
I am unable to view the schema browser data grid for SYS schema objects. I can view the columns, indexes, constraints,etc., but the moment I select
the data tab I get this error: ORA-00942: table or view does not exist. The primary culprit is the sys.audit$ table. And it's
only the data tab in the schema browser that causes the error. I am logged into the database as the system user. -
Resolution
Needed to grant Select on aud$ and audit$ tables explicitly, even to the system user.