SYSTEM cmd fails w/ non-informix user connecting via ODBC
Posted in 1999
Topics: Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET, Server Administration
We are running Informix 7.30UC3 under HPUX 10.20 and are connecting to this
database via ODBC from an NT server running IIS4 and asp. We have a stored
procedure which executes some SYSTEM commands that works fine over ODBC
if the connection is made by the informix user. However, we don't want the
connections to be made by the informix user, and have created another user
to be used for these connections.
The SYSTEM command states that the stored procedure must be owned by the
user executing it in order for the SYSTEM commands to execute, so we
have created the stored procedure as this new user.
If I don't connect via ODBC (login and use dbaccess, access via sqleditor),
the SYSTEM commands run perfectly as this user. Only through ODBC do the
SYSTEM commands fail. SELECTS, INSERTS, CREATES, etc... all work fine if
granted the appropriate permissions. Permissions on the filesystem are
fine. Even the simplest SYSTEM 'touch /tmp/test.txt' fails to execute
over ODBC.
Does anyone have any suggestions?
Regards,
Kevin
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own