pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

ODBC Security Concerns
2+ messages / 2 participants
[nested] [flat]

* ODBC Security Concerns
@ 2000-07-05 20:51 jeam@themail.com
  2000-07-06 01:31 ` Re: ODBC Security Concerns Carolyn Lu Wong <carolyn@greatpacific.com.au>
  0 siblings, 1 reply; 2+ messages in thread

From: jeam@themail.com @ 2000-07-05 20:51 UTC (permalink / raw)
  To: pgsql-interfaces


Hi,

Don't know the security options of the ODBC driver, so I have this questions:

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?

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?

Many thanks in advance,

Jorge. 
__________________________________________________________________
Make A Buck Or Two @ TheMail.com - Free Internet Email
Sign-up today at http://www.themail.com/ref.htm?ref=908313 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: ODBC Security Concerns
  2000-07-05 20:51 ODBC Security Concerns jeam@themail.com
@ 2000-07-06 01:31 ` Carolyn Lu Wong <carolyn@greatpacific.com.au>
  0 siblings, 0 replies; 2+ messages in thread

From: Carolyn Lu Wong @ 2000-07-06 01:31 UTC (permalink / raw)
  To: jeam@themail.com; +Cc: 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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2000-07-06 01:31 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-07-05 20:51 ODBC Security Concerns jeam@themail.com
2000-07-06 01:31 ` Carolyn Lu Wong <carolyn@greatpacific.com.au>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox