Re: Current database access

[Chris Albertson <chrisja@jps.net>]

Gutzwiller, Michael wrote:
> 
> I'm trying to access the current database without success.  My current
> ODBC settings are:
> 
> server          a188-1004.rit.edu
> database        tass
> port            5432
> username        guest
> 
> I've also tried the database names testdb, and tassdb without luck.

Don't know if you got my answer I sent last week or not.  I was using
a makeshift e-mail connection.

I just tried connecting and it appears like Micheal is no longer
setup for remote access. The name "a188-1004.rit.edu" may not
be correct.  Lookups fail for me.  Try "www.tass-survey.org"
as this should always point to the TASS computer.

In the past M. R. has used the Postgres "HBA" or Host Based Access
feature of Postgres.  I think now this is turned off by default so
it could have beed disabled during a server version upgrade.  He needs
to look at the file "/usr/local/pgsql/data/pg_hba.conf".  the
comments and examples in the file are pretty clear.

The whole area of access control needs to be thought through.  Postgres
can control access table by table.  We could allow anyone read access
but some selected users write access to some tables.  It is also
possable to allow users to create thier own tables to which they and
anyone sharing tier username (guest) have read and write access.


-- 
   --Chris Albertson             home: chrisja@jps.net        
     Redondo Beach, California   work: chris@topdog.logicon.com