On Tue, 25 May 1999, Jim Burnett wrote:
> In access when I try to link a table I get an authentication failed. I
> tried to add a user using createuser, but i didnt pompt me for a
> password. Also, do i need to add users to each database i make or just
> using the createuser in ./bin ? i tried to use the postgres account
> and get the the postgre database but it gave me the same message.l
pgsql, differently from mysql, trusts the username has been adequately
authenticated by the system login. You must, however, grant permissions
for the databases to the users. The SQL grant command should handle this -
however, to link to the table you might have to allow superuser access
(this is something I've never tried, but seems possible) which I've only
managed to add through createuser. Try giving full privs and then
tailoring from there.
Don't know why postgres is failing. Perhaps your problem is even deeper :)
cr
