Re: login role password

Поиск
Список
Период
Сортировка
От Michael Shapiro
Тема Re: login role password
Дата
Msg-id CAGCvxea85Ve3RPvGSUtbdOU4ubDeQqV1rGJzBfEP5_ZGdSc0mQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: login role password  (Isaías Sánchez <isaias.sanchez.l@gmail.com>)
Список pgadmin-support
Дерево обсуждения
Thanks.  That is a helpful workaround.

I am asking for this functionality to be added to PgAdmin4, so that when you select the SQL for a login role you see what PgAdmin3 shows.

  CREATE ROLE xxx_user LOGIN
    ENCRYPTED PASSWORD 'md5f349771b7d83b170e8377bd7d09'
    SUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION;

And that the dialog for a login user supports setting an encrypted password.

I know I can run this in an SQL window:

  ALTER ROLE xxx_user ENCRYPTED PASSWORD 'md5f349771b7d83b170e8377bd7d09';

but it would be nice if PgAdmin4 supported this in the GUI

On Tue, Jun 4, 2019 at 8:40 AM Isaías Sánchez <isaias.sanchez.l@gmail.com> wrote:
Just: select * from pg_authid;

En 4 de junio de 2019 15:14:49 Michael Shapiro <mshapiro51@gmail.com> escribió:

PgAdmin3 has the ability to see the encrypted password for a login role. That allow me to copy the login role password from one server to another (without having to know the password). 

I don't see how to see the encrypted password for a login role in PgAdmin4


В списке pgadmin-support по дате отправления:

Предыдущее
От: Isaías Sánchez
Дата:
Сообщение: Re: login role password
Следующее
От: Michelle Schwan
Дата:
Сообщение: pgAdmin IV