Accessing DB of non-user name
От | Toni Hermoso |
---|---|
Тема | Accessing DB of non-user name |
Дата | |
Msg-id | 20020822010846.7e7249b2.toniher@arrakis.es обсуждение исходный текст |
Ответы |
Re: Accessing DB of non-user name
|
Список | pgsql-admin |
Hello list, I'm trying PostgreSQL having previous experience with MySQL. I have got the following problem: I want to allow database access to a user (username1) to a database with a name different to the same user (which may ornot be created by such user). But I do not manage. I have the following entries in pg_hba.conf: host sameuser 127.0.0.1 255.255.255.255 md5 host all 127.0.0.1 255.255.255.255 md5 admins Allowing TCP/IP access restricted to localhost to users with same database name and allowing TC/IP access to all databases by superusers (admin group). Anyway I cannot manage one user: user1 may access database user2, f.instance I tried host user2 127.0.0.1 255.255.255.255 user1group -> whre user1group refers to pg_ident map. On the other hand when I add this line (wherever upper or lower to 2 previous ones) I cannot access user2 database thru'superusers. When 'host all' line is substituted by an equivalent local all md5 admins -> I haven't got the last problem, but I cannotconnect to user2 thu' user1 yet. I tried grant tables and other objects if present with no result. What am I missing? Thanks! -- Toni Hermoso Pulido ------------------------------------------------------ web: http://www.arrakis.es/~toniher email: toniher@arrakis.es toni.hermoso@hispalinux.es pgp_public_key: http://www.arrakis.es/~toniher/toniher.pgp *** Cífratelo, cífraselo *** ------------------------------------------------------
Вложения
В списке pgsql-admin по дате отправления: