Access setting for users, problem

From: "Kaj-Michael Lang" <milang(at)tal(dot)org>
To: <pgsql-admin(at)hub(dot)org>
Subject: Access setting for users, problem
Date: 1998-05-21 11:34:35
Message-ID: 000601bd84c8$c0b58890$09c8d0c1@amos.sip.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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.

How do I do it ?

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mike Edwards 1998-05-21 12:01:50 postgreSQL 6.3.2-3 RPM?
Previous Message Bruce Momjian 1998-05-21 02:40:28 Re: [ADMIN] initdb failing on a WARN:heap_modifytuple error