| From: | Jameson Burt <jameson(at)mnsinc(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Cc: | jameson(at)coost(dot)com |
| Subject: | All users can enter as one user "puser" without superuser priviledges: how? |
| Date: | 2001-12-17 06:42:02 |
| Message-ID: | 20011217014202.A31762@rabbit.burtnet |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I seek a simplistic access,
1. superuser "postgres" gets access when his system-name is "postgres",
but not otherwise [some security sought].
This can be done in pg_hba.conf with either
local all peer sameuser
local all trust #but anyone then gets "postges" access.
2. One other user, say "puser", gets access whatever his system-name.
The above
local all peer sameuser
disallows an arbitrary username entering as "psql template1 -U puser".
One can use
host all 127.0.0.1 255.0.0.0 ident jimsmap
then have pg_ident.conf with 1000 user entries like
jimsmap jameson puser
However, I seek a simpler method for numerous users,
each of whom will be granted access as user "puser".
ANY IDEAS?
--
Jameson C. Burt, NJ9L Fairfax, Virginia, USA
jameson(at)coost(dot)com http://www.coost.com
(202) 690-0380 (work)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew G. Hammond | 2001-12-17 08:59:22 | Re: All users can enter as one user "puser" without |
| Previous Message | Chris Ruprecht | 2001-12-16 16:17:53 | Re: Shared Memory |