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