Re: ODBC with informix

Posted in 1998

Topics: Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing

Matt Reprogle — Fri, 20 Mar 1998 09:32:46 -0500 — source: Informix-list mailing list archive (1991-1998)

Jay Hannah wrote: > > Killspamrs wrote: > > Along this line, but completely different, in an NT/win 95 environment is it > > possible to completely disable all ODBC connectivity from within Informix? I > <snip!> > > Since syscolsauth will say they have add/change/delete god knows what they > > could do. > > If you don't trust these users w/ delete/mod access, why do they have it > in the first place? Revoke priviledges in Informix, and they're locked > out no matter what client (ODBC or otherwise) they use. > > Have I missed something? > > Jay Perhaps. In some situations, users have an "approved" application through which they are allowed to perform modifications, but you do not want them to have unrestricted SQL-level access through ODBC-enabled tools like MS-Query. -- Matt Reprogle IS Engineer, Delphi Delco Electronics Systems phone:(765)451-9651 FAX: (765)451-8230 mcreprog@ictest.delcoelect.com