Re: Cannot connect to the database (PG 7.3)
От | Michiel Lange |
---|---|
Тема | Re: Cannot connect to the database (PG 7.3) |
Дата | |
Msg-id | 5.1.0.14.0.20030127141542.00b34a88@192.168.1.3 обсуждение исходный текст |
Ответ на | Re: Cannot connect to the database (PG 7.3) (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Cannot connect to the database (PG 7.3)
Re: Cannot connect to the database (PG 7.3) |
Список | pgsql-admin |
it is at connect-time, so there is nothing done with set session authorization. I just want to connect, and read data from a table to which the group the user is in has read-access. I have tried if it would differ when I try to connect with a user created like: CREATE USER 20020003 WITH ENCRYPTED PASSWORD 'secret'; or CREATE USER 20020004 WITH UNENCRYPTED PASSWORD 'secred'; it would not matter... even if there really is a trust-relation between my computer and the other machine in pg_hba.conf it is pretty strange... might it be a bug? Thanks for the try though, Michiel At 19:42 26-1-2003 -0500, Tom Lane wrote: >Michiel Lange <michiel@minas.demon.nl> writes: > > I get this error message: > > psql: FATAL: permission denied > >As near as I can tell, you must have some code that is trying to do >SET SESSION AUTHORIZATION --- which only a superuser is allowed to do. >Evidently user 20020003 isn't one. > > regards, tom lane
В списке pgsql-admin по дате отправления: