Re: restrict odbc-access

Posted in 1998

Sujit.Pal@alltel.com — Tue, 30 Jun 1998 11:43:20 -0500 — source: Informix-list mailing list archive (1991-1998)

Klaus = One way to do this would be to set a role which has connect to the = tables in the database, revoke connect rights from public except a = login/password table, setup a login/password HTML page at the browse= r = end, and validate the password against this table. If validation = succeeds, then set the role and do whatever the cgi does. = HTH = Sujit Pal ______________________________ Reply Separator __________________________= _______ Subject: restrict odbc-access Author: Klaus Gotthardt <k.gotthardt@em.uni-frankfurt.de> at internet Date: 6/30/98 2:59 PM We are using odbc in a cgi-application to an informix database. We do = not want to give anonymous users connect rights to the database (only = select rights to a view). How can we restrict the rights? = = Thanks for any suggestions. = = -- = Klaus Gotthardt, Johann Wolfgang Goethe-Universit=E4t,Verwaltungsdatenverarbeitung = Email: K.Gotthardt@em.uni-frankfurt.de = Tel:+49 (0)69-798-23380 = Fax:+49 (0)69-798-23381 = Home,pgp-key: http://www.rz.uni-frankfurt.de/~gotthard