Re: ODBC Security Concerns

From: Carolyn Lu Wong <carolyn(at)greatpacific(dot)com(dot)au>
To: jeam(at)themail(dot)com
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: ODBC Security Concerns
Date: 2000-07-06 01:31:38
Message-ID: 3963E17A.CFE1461D@greatpacific.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

> 1.-By checking the CommLog box on the driver, 'psqlodb.log' is created with the password listed there. So some clever user can just go and tamper with the driver and he'll find a way into the database.
> Can this be prevented?

When configuring the ODBC driver, do not fill in the database, server,
username, password fields and uncheck the log option (I can't remember
the exact name for this). Setup the database connection string in your
program.

Hope this helps.

>
> 2.- Inside pg_hba.conf, in the record type "host" lines, the USERAUTH options are 'trust','reject','password', etc.
> Is it possible to use the 'crypt' option when connecting via ODBC? What are the proper steps to accomplish this?
>

I'd like to know the answer to this one too.

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message M.Mazurek 2000-07-06 09:09:13 Re: BLOBS with jdbc
Previous Message Cesar A. K. Grossmann 2000-07-05 20:57:56 Visual Basic/ODBC/PostgreSQL