pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: pinker <pinker@onet.eu>
To: pgsql-admin@postgresql.org
Subject: Re: Acess Control !
Date: Tue, 3 Oct 2017 14:55:15 -0700 (MST)
Message-ID: <1507067715071-0.post@n3.nabble.com> (raw)
In-Reply-To: <CAJJTqWT-17TXbQe0NfkMBQe+tG39nT1ojtCatu=Mv8gjxD_Gbw@mail.gmail.com>
References: <CAJJTqWT6FPxptJKuPVmDqjwE8GgX7ANtjDC+Shx89p+KPczzOw@mail.gmail.com>
	<CAKFQuwaFH-QKdQUUWfRDnJcHOx5cpMoy5d5RGG4hO=xaX+8B7Q@mail.gmail.com>
	<CAJJTqWQWRgCQyVR1Zvs_vvVmEW+RK=6k2+kZBxA=kSCvAXbycQ@mail.gmail.com>
	<CAKq0gv+CxtK72wn3-rymeyt0NJqeKqLjj4wWwK+himG3HpUmuw@mail.gmail.com>
	<CAJJTqWT-17TXbQe0NfkMBQe+tG39nT1ojtCatu=Mv8gjxD_Gbw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

be careful with order change. This proposed by Scott was correct; yours will
reject all the connections made by user system to xpto. Documentation says:

> The first record with a matching connection type, client address,
> requested database, and user name is used to perform authentication. There
> is no "fall-through" or "backup": if one record is chosen and the
> authentication fails, subsequent records are not considered.





--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



view thread (10+ messages)  latest in thread

Message-ID: <1507067715071-0.post@n3.nabble.com>
Permalink:  ../1507067715071-0.post@n3.nabble.com/
Also on:    postgresql.org/message-id/1507067715071-0.post@n3.nabble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: pinker@onet.eu
  Subject: Re: Acess Control !
  In-Reply-To: <1507067715071-0.post@n3.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox