Обсуждение: Re: [ADMIN] Access setting for users, problem

Поиск
Список
Период
Сортировка

Re: [ADMIN] Access setting for users, problem

От
"Kaj-Michael Lang"
Дата:
>> 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* the
ownerof the db has access to it. I haven't found anything in the docs on this. 

/--------------------------------------------------------------------\
| Kaj-Michael Lang        | WWW:    http://www.tal.org               |
| Kaskentie 5 C9          | E-Mail: milang@tal.org                   |
| 20720 Turku             |         milang@onion.sip.fi              |
| FINLAND                 |         milang@infa.abo.fi               |
|-------------------------|         klang@abo.fi                     |
| GSM: +358-(0)40-5271058 | FTP:    ftp://ftp.tal.org                |
|--------------------------------------------------------------------|
|     CS@ÅA      DBMS&CGI&PHP&HelpDesk&PTRoot&Coding@SIP Ltd         |
| Software is like sex; it's better when it's free. - Linus Torvalds |
\--------------------------------------------------------------------/






Re: [ADMIN] Access setting for users, problem

От
Bruce Momjian
Дата:
>
> >> 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)