Accessing DB of non-user name

Поиск
Список
Период
Сортировка
Искать
От
Toni Hermoso
Тема
Accessing DB of non-user name
Дата
Msg-id
20020822010846.7e7249b2.toniher@arrakis.es
Список
Дерево обсуждения
Accessing DB of non-user name Toni Hermoso <toniher@arrakis.es>
Re: Accessing DB of non-user name Bruno Wolff III <bruno@wolff.to>
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 or not 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 cannot connect 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 по дате отправления
От: Elielson Fontanezi
Дата:
От: Tim Ellis
Дата:
FAQ