From: | "Dominic J(dot) Eidson" <sauron(at)the-infinite(dot)org> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Allowing usernames in pg_hba.conf |
Date: | 2002-03-11 18:08:36 |
Message-ID: | Pine.LNX.4.33.0203111206580.23718-100000@morannon.the-infinite.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 11 Mar 2002, Bruce Momjian wrote:
> Lincoln Yeoh wrote:
> > Is there a way to grant another user access (full/limited) to an entire
> > database?
> >
> > Right now pg_hba.conf controls connectivity to a database.
> >
> > However from the docs it seems that one has to do a grant for _every_
> > table. if a new table is created the user can't access it. This can be
> > annoying in some situations.
>
> Table access and database access are different issues. One is controled
> by pg_hba.conf and other by GRANT. There is no mass-GRANT capability.
I'd started a long-ish post about how pgsql should have a proper
permission model for user-to-database access - when someone pointed me to
the following url, which I'd like to bring to everybody's attention:
http://candle.pha.pa.us/cgi-bin/pgtodo?privileges
Is this something PeterE's still looking at doing for 7.(I guess 3, now?)
--
Dominic J. Eidson
"Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-03-11 18:10:15 | Re: Allowing usernames in pg_hba.conf |
Previous Message | Debian User | 2002-03-11 17:28:19 | Object?? -Relational DBMS Postgresql are you sure? |