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 ***
------------------------------------------------------
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 ???? |