Re: Defining Role Privileges - Mailing list pgsql-general

From Jasen Betts
Subject Re: Defining Role Privileges
Date
Msg-id jh58oj$lrh$3@reversiblemaps.ath.cx
Whole thread Raw
In response to Defining Role Privileges  (Carlos Mennens <carlos.mennens@gmail.com>)
List pgsql-general
On 2012-02-08, Carlos Mennens <carlos.mennens@gmail.com> wrote:

> ALTER ROLE tom ENCRYPTED PASSWORD 'md5081bea17b5503506d29531af33cc6f4e';
>
> \password tom
>
> Is there a downside to using the \password psql command? Is it also
> encrypted like the statement above? How do you create roles and do you
> do it manually or have some kind of template?

I checked that a few weeks ago when doing the latter version the
password is translated into a form similar to former version
your chosen new password is sent over the wire encrypted.

--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Let-bindings in SQL statements
Next
From: Jasen Betts
Date:
Subject: Re: Let-bindings in SQL statements