'ORA-00942: Table or View does not exist' error when referencing a custom table/view in a report query in RSA Identity Governance & Lifecycle
Originally Published: 2015-06-30
Last Modified: 2023-10-06
Article Number
Applies To
RSA Version/Condition: 7.0.x, 7.1.x, 7.2.x
Issue
com.aveksa.server.runtime.ServerException:
com.aveksa.server.runtime.ServerException:
java.sql.SQLSyntaxErrorException: ORA-00942:
table or view does not exist
com.aveksa.server.runtime.ServerException:
java.sql.SQLSyntaxErrorException: ORA-00942:
table or view does not exist
Cause
Resolution
- Login to SQL as the avuser
- Execute the following SQL grant statement:
grant select on <table | view> to avdwuser
For example:
grant select on custom_table_1 to avdwuser
Notes
$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.
Related Articles
Updated: SecurID Announces the Upcoming Release of the iOS and Android App 11Number of Views ORA-20126 in Review Definition User Selection query with custom table in the AVCSUSER schema in RSA Governance & Lifecycle 100Number of Views How to run a SQL query for Authentication Manager 8.0 or 8.1 and write the output to a file for support 784Number of Views Collector reports ORA-12805: parallel query server died unexpectedly, in RSA Identity Governance & Lifecycle 138Number of Views Data runs show error: Exception while executing filter query RSA Identity Governance & Lifecycle 6.8 and above 240Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?