Dominic J. Eidson wrote:
>
> 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?)
I assume it is coming in as part of schemas. Tom?
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026