Обсуждение: Encrypted role password

Поиск
Список
Период
Сортировка

Encrypted role password

От
Mark Watson
Дата:

Good day all,

First of all, thank you for the good work with pgAdmin4.

My question is, in pgAdmin3, the SQL pane for the role create script shows the md5 encrypted password. Are there any plans to display this for pgAdmin4 ?

 

Mark Watson

 

Re: Encrypted role password

От
Melvin Davidson
Дата:
I am not pgadmin support, but if you are a superuser,
you can get the password with:

SELECT rolname,
       rolpassword
  FROM pg_authid
WHERE rolname = 'username';





Melvin Davidson 🎸
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com



On Friday, September 29, 2017, 10:21:58 AM EDT, Mark Watson <mark.watson@jurisconcept.ca> wrote:


Good day all,

First of all, thank you for the good work with pgAdmin4.

My question is, in pgAdmin3, the SQL pane for the role create script shows the md5 encrypted password. Are there any plans to display this for pgAdmin4 ?

 

Mark Watson

 

RE: Encrypted role password

От
Mark Watson
Дата:

De : Melvin Davidson [mailto:melvin6925@yahoo.com]

 

I am not pgadmin support, but if you are a superuser,

you can get the password with:

 

SELECT rolname,
       rolpassword
  FROM pg_authid
WHERE rolname = 'username';

-----------------------------------

Thanks, Melvin

It’s also available in pg_shadow. I was just having a lazy day :)

 

 

On Friday, September 29, 2017, 10:21:58 AM EDT, Mark Watson <mark.watson@jurisconcept.ca> wrote:

 

 

Good day all,

First of all, thank you for the good work with pgAdmin4.

My question is, in pgAdmin3, the SQL pane for the role create script shows the md5 encrypted password. Are there any plans to display this for pgAdmin4 ?

 

Mark Watson