Re: Allowing usernames in pg_hba.conf

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