A non-DBA user may receive the following error, when accessing a remote table:
java.sql.SQLException: [Sybase][ODBC Driver] [Sybase IQ]Permission denied: you do not have permission to insert into ''omni_rset_fetch_table''
The workaround for this problem is to log in as a DBA user and execute the following command:
GRANT SELECT,INSERT,UPDATE,DELETE ON dbo.omni_rset_fetch_table TO PUBLIC
This problem is addressed in a future release.