>
> >> We are going to give all our shell users access to Postgres so that
> >> every user has their own database that they use as much as they like but
> >> so that they can't create new databases. Also these databases should be
> >> totaly private to the user that owns it (ok, the "postgres" should have
> >> access to them) so that nobbody else can
> >> connect/select/insert/update/create/drop/etc.
> >
> >The short answer: use the 'createuser' command via the postgres superuser
> >and follow the instructions
> >
> >The long answer: read the PostgreSQL Administrator's Guide. It describes
> >it more detail how to set up users and access to different databases.
>
>
> I did just that... but it did't say anything about howto restrict a db to just ONE user. I wan't it so that *only*
theowner of the db has access to it. I haven't found anything in the docs on this.
pg_hba.conf
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)