postgres user authentification

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: postgres user authentification
Date: 2001-10-24 20:47:13
Message-ID: 20011024204715.528D62AB49@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a light pg_hba.conf file:

local all trust
host all 127.0.0.1 255.255.255.255 trust

Which doesn't look so bad, just because at the server there are few accounts,
and all from admins. But is there a way to make it imposible to do this:

webunl=> \c - postgres
You are now connected as new user postgres.
webunl=#

I mean, I don't want others to simply do a \c - postgres and thats all. Is it
posible without changing the trust for a password?

Saludos... :-)

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

Browse pgsql-general by date

  From Date Subject
Next Message X 2001-10-24 20:47:53 RESOLVED : Re: sql script questions
Previous Message Peter Pilsl 2001-10-24 20:36:34 variables in functions ..