MIME-Version: 1.0
References: 
 <CALfOM6KtjqpO5pYgmpUmDScJMeftv9r509HfYLo2b8gebviL3g@mail.gmail.com>
 <dcfb2083-e968-6715-1d27-cbf325ab9037@jakobs.com>
In-Reply-To: <dcfb2083-e968-6715-1d27-cbf325ab9037@jakobs.com>
From: Daulat <daulat.dba@gmail.com>
Date: Thu, 20 Jan 2022 16:41:59 +0530
Message-ID: 
 <CALfOM6KG2WCLs3ErwGo8hEk0sMeZns42SKNdJF8xXWdO2_Acbg@mail.gmail.com>
Subject: Re: Password authorization
To: Holger Jakobs <holger@jakobs.com>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d4db3205d6019268"
Archived-At: 
 <https://www.postgresql.org/message-id/CALfOM6KG2WCLs3ErwGo8hEk0sMeZns42SKNdJF8xXWdO2_Acbg%40mail.gmail.com>
Precedence: bulk

--000000000000d4db3205d6019268
Content-Type: text/plain; charset="UTF-8"

Hi Holger,

Is there any change related to password management in Postgres14 with
respect to previous releases. I don't see anything new.

Thanks

On Thu, Jan 20, 2022 at 3:36 PM Holger Jakobs <holger@jakobs.com> wrote:

> Am 20.01.22 um 10:56 schrieb Daulat:
> > Hi Team,
> >
> > Do we have any facility for password authorisation in Postgres same as
> > in Oracle?
> > In Oracle, a user can change their password based upon the
> > profile setting. What about in Postgres ?
> >
> > Is there any alternative in postgres to manage the user password
> > authorisation?
> > What about LDAP with respect to this approach?
> > Please suggest.
> >
> > Thanks.
> >
> >
>
> https://www.postgresql.org/docs/14/sql-alterrole.html contains the
> sentence:
>
>      Ordinary roles can only change their own password.
>
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>

--000000000000d4db3205d6019268
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Holger,<div><br><div>Is there any change related to pas=
sword management in Postgres14 with respect to previous releases. I don&#39=
;t see anything new.</div><div><br></div><div>Thanks</div></div></div><br><=
div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Jan=
 20, 2022 at 3:36 PM Holger Jakobs &lt;<a href=3D"mailto:holger@jakobs.com"=
>holger@jakobs.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex">Am 20.01.22 um 10:56 schrieb Daulat:<br>
&gt; Hi Team,<br>
&gt;<br>
&gt; Do we have any facility=C2=A0for password authorisation in Postgres sa=
me as <br>
&gt; in Oracle?<br>
&gt; In Oracle, a user can change their password based upon the <br>
&gt; profile=C2=A0setting. What about in Postgres ?<br>
&gt;<br>
&gt; Is there any alternative in postgres to manage the user password <br>
&gt; authorisation?<br>
&gt; What about LDAP with respect to this approach?<br>
&gt; Please suggest.<br>
&gt;<br>
&gt; Thanks.<br>
&gt;<br>
&gt;<br>
<br>
<a href=3D"https://www.postgresql.org/docs/14/sql-alterrole.html" rel=3D"no=
referrer" target=3D"_blank">https://www.postgresql.org/docs/14/sql-alterrol=
e.html</a> contains the sentence:<br>
<br>
=C2=A0=C2=A0=C2=A0=C2=A0 Ordinary roles can only change their own password.=
<br>
<br>
<br>
-- <br>
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012<br>
<br>
</blockquote></div>

--000000000000d4db3205d6019268--