2 Workarounds for this bug:Option 1) use the Oracle9i client libraries on the client machine and it works fine: sde:oracle9i. However user wants to use 10g client libraries for better performance. Option 2) Grant "Select ANY Table" to the T2 User in Oracle SQLPLUS. This works, however this causes slower connection times and user does not want to reveal all layer to users.