Access setting for users, problem - Mailing list pgsql-admin

From Kaj-Michael Lang
Subject Access setting for users, problem
Date
Msg-id 000601bd84c8$c0b58890$09c8d0c1@amos.sip.fi
Whole thread Raw
Responses Re: [ADMIN] Access setting for users, problem  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
List pgsql-admin
We are going to give all our shell users access to Postgres so that every user has their own database that they use as
muchas they like but so that they can't create new databases. Also these databases should be totaly private to the user
thatowns it (ok, the "postgres" should have access to them) so that nobbody else can
connect/select/insert/update/create/drop/etc.

How do I do it ?

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



pgsql-admin by date:

Previous
From: Mike Edwards
Date:
Subject: postgreSQL 6.3.2-3 RPM?
Next
From: "Brett W. McCoy"
Date:
Subject: Re: [ADMIN] Access setting for users, problem