From: | <kynn(at)panix(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Selective authentication? |
Date: | 2005-08-25 19:31:45 |
Message-ID: | 200508251931.j7PJVj324561@panix3.panix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I'm setting up PostgreSQL for a small academic lab, where I work. The
host OS is Linux (Debian). I want to allow most users to connect to
the database without having to supply a password, but I want to have a
special user, called dbadmin, with superuser privileges. The idea is
that I (or whoever gets entrusted with this responsibility) would
connect as dbadmin *only* when the task at hand required superuser
privileges.
I'd be very grateful if someone could explain to me how to set this
up.
(If there were a simple way to obviate the need to type in a password
every time (e.g. through a suitable command in a configuration file,
such as one can do with ${HOME}/.my.cnf), then I could just require a
password from everyone, but I have not found out how to do this in
PostgreSQL.)
Many thanks in advance!
kj
From | Date | Subject | |
---|---|---|---|
Next Message | Charley L. Tiggs | 2005-08-25 20:10:22 | Re: Selective authentication? |
Previous Message | operationsengineer1 | 2005-08-25 18:46:13 | Copy Failure |