On Oracle 9i and 10g database, my application shows such error. "The original DB connection has access to multiple schemas. Limit access to the required schema for the user." How can I decide?
Sounds to me like a message from your application (or the tool it uses to connect to Oracle), not a message from Oracle itself.