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
