Can not view schema browser data grid for SYS schema objects, error ORA-00942 (41218)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

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.

Feedback submitted.

Was this article helpful?

[Select Rating]

Title