Re: Allowing usernames in pg_hba.conf

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.

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