From: | "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com> |
---|---|
To: | Kaj-Michael Lang <milang(at)tal(dot)org> |
Cc: | pgsql-admin(at)hub(dot)org |
Subject: | Re: [ADMIN] Access setting for users, problem |
Date: | 1998-05-21 15:17:38 |
Message-ID: | Pine.LNX.3.96.980521111524.3188A-100000@dragosani.lan2wan.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Thu, 21 May 1998, Kaj-Michael Lang wrote:
> 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.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
"The number of UNIX installations has grown to 10, with more expected."
-- The UNIX Programmer's Manual, 2nd Edition, June, 1972
From | Date | Subject | |
---|---|---|---|
Next Message | Kaj-Michael Lang | 1998-05-21 21:53:49 | Re: [ADMIN] Access setting for users, problem |
Previous Message | Mike Edwards | 1998-05-21 12:01:50 | postgreSQL 6.3.2-3 RPM? |