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.
Needed to grant Select on aud$ and audit$ tables explicitly, even to the system user.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy