Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_authid.rolpassword format (was Re: [HACKERS] Passwordidentifiers, protocol aging and SCRAM protocol) - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: pg_authid.rolpassword format (was Re: [HACKERS] Passwordidentifiers, protocol aging and SCRAM protocol)
Date
Msg-id CAB7nPqSfWto4Spvo3pzvPo4QaTwRFJCdBGh=vPOnK+Cc4-Dbgw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Password identifiers, protocol aging and SCRAM protocol  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Tree view 
On Wed, Dec 21, 2016 at 1:08 AM, David Fetter <david@fetter.org> wrote:
> Would a view that shows only what's to the left of the first semicolon
> suit this purpose?

Of course it would, you would just need to make the routines now
checking the shape of MD5 and SCRAM identifiers available at SQL level
and feed the strings into them. Now I am not sure that it's worth
having a new superuser view for that. pg_roles and pg_shadow hide the
information about verifiers.
-- 
Michael

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [HACKERS] Clarifying "server starting" messaging in pg_ctl startwithout --wait
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Clarifying "server starting" messaging in pg_ctl startwithout --wait