Strange ORA-01031 issue

From: <rogergorden_at_gmail.com>
Date: 24 Jan 2007 09:54:58 -0800
Message-ID: <1169661298.227731.193360@v33g2000cwv.googlegroups.com>

All;

I have 2 schemas on an Oracle 9.2.0.5.0 box.

When I connect to schema A remotely via a Web App using JSP/XSQL it works fine, with no errors.

When I connect to schema B with the same app, (just different username/password) via JS/XSQL it won't connect with an ORA-01031: insufficient privileges.

I can connect to schema B via SQLPLUS/SQLNavigator and run the offending query just fine.

I have checked the permissions vi OEM and both schemas appear to have the same permissions.

Is there something regarding XSQL and permissions that I am missing here.

Thanks. Received on Wed Jan 24 2007 - 11:54:58 CST