We enabled Oracle tracing as we could not identify the cause of this problem.
At login, we got following errors.
SQL Error: 1031, SQLState: 42000 ORA-01031: insufficient privileges
We have multiple FMS' sharing the same Oracle instance but with different schema for each FMS. The issue is on only one of the FMS' which is pb-foglight-02, and it is using PB_FOGLIGHT_02 schema, but when we look at the trace file, it is trying to call update on PB_FOGLIGHT_04.sec_user which belongs to a different schema for a different FMS (pb-foglight-04), that explains why we are getting the insufficient privilege error becaues it is trying to update a table belongs to a different schema.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center