Accessing DB of non-user name

From: Toni Hermoso <toniher(at)arrakis(dot)es>
To: pgsql-admin(at)postgresql(dot)org
Subject: Accessing DB of non-user name
Date: 2002-08-21 23:08:46
Message-ID: 20020822010846.7e7249b2.toniher@arrakis.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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(at)arrakis(dot)es
       toni(dot)hermoso(at)hispalinux(dot)es

pgp_public_key:
http://www.arrakis.es/~toniher/toniher.pgp
       
        *** Cífratelo, cífraselo ***
------------------------------------------------------

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tim Ellis 2002-08-21 23:18:21 Re: OT: password encryption (salt theory)
Previous Message Robert Treat 2002-08-21 22:23:19 Re: Event recurrence - in database or in application code ????