After upgrade, read-only user cannot find table in Oracle.
- Product: Voyager
- Product Version: All
- Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care
Problem Symptoms
- After upgrade, read-only user cannot find table in Oracle.
- Query or describe table results in error:
ERROR:
ORA-04043: object "XXXDB"."[table name]" does not exist
Cause
This problem may occur if the read-only Oracle user needs to be rebuilt.
Resolution
If you are experiencing these symptoms, try rebuilding the read-only Oracle user.
If you are a TotalCare customer or would prefer Support do this, please open a Case via the Support Portal.
Additional Information
Instructions for rebuilding read-only user: Create & refresh Oracle read-only users for ODBC
- Article last edited: 02-Mar-2016