Re: Roles with passwords; SET ROLE ... WITH PASSWORD ? - Mailing list pgsql-general

From Tom Lane
Subject Re: Roles with passwords; SET ROLE ... WITH PASSWORD ?
Date
Msg-id 12704.1259766282@sss.pgh.pa.us
Whole thread Raw
In response to Roles with passwords; SET ROLE ... WITH PASSWORD ?  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: Roles with passwords; SET ROLE ... WITH PASSWORD ?  (Michael Gould <mgould@intermodalsoftwaresolutions.net>)
Re: Roles with passwords; SET ROLE ... WITH PASSWORD ?  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Craig Ringer <craig@postnewspapers.com.au> writes:
> Anyway ... I'm curious about whether `SET ROLE rolename WITH PASSWORD'
> is something that's technically practical to implement in PostgreSQL and
> what people think about the idea.

Seems like it would have all the standard problems with cleartext
passwords being exposed in pg_stat_activity, system logs, etc.
Also, what about people who are using more-secure-than-password
auth methods, like Kerberos?

I'm not really for it.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres Dump out of order
Next
From: "Albe Laurenz"
Date:
Subject: Re: quote string exactly as it is