000030679 - 'ORA-00942: Table or View does not exist' error when referencing a custom table/view in a report query in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Mar 16, 2020
Version 7Show Document
  • View in full screen mode

Article Content

Article Number000030679
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0.x, 7.1.x, 7.2.x
IssueWhen creating a new report (Reports > Tabular/ChartsCreate Report) or when editing an existing report (Reports > Tabular/Charts > {report_name} > Edit) and referencing a custom table under the Query tab, the following error occurs:
java.sql.SQLSyntaxErrorException: ORA-00942:
          table or view does not exist

User-added image

CauseThis error occurs because the report user, avdwuser, does not have select privileges on the custom table/view referenced in the query.
ResolutionTo resolve this issue, grant select on the custom table to the avdwuser.
  1. Login to SQL as the avuser
  2. Execute the following SQL grant statement:

grant select on <table | view> to avdwuser

For example:

grant select on custom_table_1 to avdwuser

NotesWhen the avdb schema is initially created, the avdwuser is given select privileges on all tables using the following script file:
$AVEKSA_HOME/database/Create Scripts/Grant_Select_To_Reports.sql 

Any tables created after the avdb schema has been created need to have the grant select statement executed manually.

Please see RSA Knowledge Base Article 000038569 -- 'Request could not be handled' error exporting metadata from RSA Identity Governance & Lifecycle for an additional problem that can occur if a custom table in the avuser schema is not granted the select privilege.