On 29/03/2011 21:21, Marc Fromm wrote:
> By editing postgresql.conf and changing listen_address = ‘*’ and editing
> pg_hba.conf and adding host all all my.ip.address allowed me to connect
> to the postgresql data base with Microsoft access.
> In access I can see the table and it fields, but if I try to use the
> table in a querry or view the table I get an error: permission denied
> for relation summer_finaid; error while executing the query (#7)
You need to grant permission on the table to the user:
GRANT SELECT ON summer_finaid TO [insert your user here];
See the docs here:
> Also in the postgresql instead of listen_address=’*’ I tried
> listen_address=’localhost, my.ip.address’ but that failed to work.
> How can I keep local host and only allow specific address? I don’t want
> to open it up to all with ‘*’
listen_addresses specifies the interfaces on which Postgres *listens*,
not the remote hosts which can connect - that's done in pg_hba.conf.
Raymond O'Donnell :: Galway :: Ireland
In response to
pgsql-odbc by date
|Next:||From: Marc Fromm||Date: 2011-03-30 14:54:45|
|Subject: Re: first time odbc|
|Previous:||From: Frank Finner||Date: 2011-03-30 04:24:27|
|Subject: Re: ODBC first time odbc|