Cannot login to Foglight console - "ORA-01031: insufficient privileges" (4316132)

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.