Re: Authenticating some users and trusting others - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Authenticating some users and trusting others
Date
Msg-id Pine.LNX.4.21.0008201341030.487-100000@localhost.localdomain
Whole thread Raw
In response to Authenticating some users and trusting others  (Lio Test <tressens@etud.insa-tlse.fr>)
List pgsql-admin
Lio Test writes:

> I want to avoid that someone could authenticate as root user on my
> databases. For this, I would like to apply "trust" access mode mixed
> with auth by password for other users. In this case, someone would
> have first to gain root privileges on my Linux system to access PG as
> root.

Perhaps you are confused. There is nothing wrong with having a database
user called "root". This user does not automatically have special
privileges and is unrelated to any Unix root user.

> Is it possible to mix two auth modes ?

Not from the same host.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-admin by date:

Previous
From: Mario Farias-Elinos Baez
Date:
Subject: Re: Netfinity x PC-clone
Next
From: m.malicky@landesmuseum-linz.ac.at
Date:
Subject: Re: Postgres Problem