Require details that can we see the password history to a User account in PostgreSQL Database.

[Sonai muthu raja M]

Dear Team,

Kindly help us to know that can we see the password history to a User account 
in PostgreSQL Database. in PostgreSQL Database.

Please do the needful since the information require for auditing purpose.

Warm regards,

M Sonai Muthu Raja
Managed Delivery Services - DBA Support
M: +919003132734
II Floor, TIDEL Park, 4 Rajiv Gandhi Salai,
Taramani, Chennai – 600 113

[cid:cbee8ac9-9b53-4e73-9b3d-c3856fc9fbeb]

www.sifytechnologies.com


DISCLAIMER: The information contained in this electronic message and any 
attachments to this message are intended for the exclusive use of the 
addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended recipient, you should not disseminate, 
distribute or copy this e-mail. Please notify the sender immediately and 
destroy all copies of this message and any attachments. Please note that 
intercepting or any unauthorized use of this message or any attachment can be 
treated as infringement of person’s right of privacy under the Human Rights Act 
1993 and also is a Criminal Offence under the Information and Technology Act, 
2008.

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email. Thank you for your cooperation.

Re: Require details that can we see the password history to a User account in PostgreSQL Database.

[Sonai muthu raja M]

Dear Adrian,

Yes, exactly. My query regarding an application user that when passwords were 
changed and what the previous values were?

Kindly let us know the above information since this detail require for an 
internal auditing purpose.

Thanks.

Warm regards,

M Sonai Muthu Raja
Managed Delivery Services - DBA Support
M: +919003132734
II Floor, TIDEL Park, 4 Rajiv Gandhi Salai,
Taramani, Chennai – 600 113

[cid:d300bf1a-9c00-4fca-989d-0ee3816b4112]

www.sifytechnologies.com<http://www.sifytechnologies.com>



From: Adrian Klaver 
Sent: Friday, April 15, 2022 9:29 PM
To: Sonai muthu raja M ; 
pgsql-general@lists.postgresql.org 
Cc: dba_support 
Subject: Re: Require details that can we see the password history to a User 
account in PostgreSQL Database.

WARNING: This email originated from outside of Sify domain. DO NOT click the 
links or open the attachments unless you recognize the sender and know the 
content is safe.



On 4/15/22 02:11, Sonai muthu raja M wrote:
> Dear Team,
>
> Kindly help us to know that can we see the password history to a User
> account in PostgreSQL Database. in PostgreSQL Database.

Do you mean when passwords where changed and what the previous values where?

Also by User account do you mean a Postgres role or an application user?

>
> Please do the needful since the information require for auditing purpose.
>
> */Warm regards,/**/
>
> M Sonai Muthu Raja
> Managed Delivery Services - DBA Support

--
Adrian Klaver
adrian.kla...@aklaver.com
DISCLAIMER: The information contained in this electronic message and any 
attachments to this message are intended for the exclusive use of the 
addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended recipient, you should not disseminate, 
distribute or copy this e-mail. Please notify the sender immediately and 
destroy all copies of this message and any attachments. Please note that 
intercepting or any unauthorized use of this message or any attachment can be 
treated as infringement of person’s right of privacy under the Human Rights Act 
1993 and also is a Criminal Offence under the Information and Technology Act, 
2008.

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email. Thank you for your cooperation.

Re: Require details that can we see the password history to a User account in PostgreSQL Database.

[Sonai muthu raja M]

Dear Adrian,

Thank you so much for the provided information.

Warm regards,

M Sonai Muthu Raja
Managed Delivery Services - DBA Support
M: +919003132734
II Floor, TIDEL Park, 4 Rajiv Gandhi Salai,
Taramani, Chennai – 600 113

[cid:81f6183b-b8da-49ea-9fd6-fea0ef9db0ff]

www.sifytechnologies.com<http://www.sifytechnologies.com>



From: Adrian Klaver 
Sent: Saturday, April 16, 2022 9:24 PM
To: Sonai muthu raja M ; 
pgsql-general@lists.postgresql.org 
Cc: dba_support 
Subject: Re: Require details that can we see the password history to a User 
account in PostgreSQL Database.

WARNING: This email originated from outside of Sify domain. DO NOT click the 
links or open the attachments unless you recognize the sender and know the 
content is safe.



On 4/16/22 00:31, Sonai muthu raja M wrote:
> Dear Adrian,
>
> Yes, exactly. My query regardingan application user that when passwords
> were changed and what the previous values were?

1) Postgres has not built in process to audit changes to it's own roles.

2) That also means it does not audit whatever you are doing in the
application above it.

3) Assuming the application user information is stored in a Postgres
table you could create a trigger on the table that stores the changes in
a separate audit table.

>
> Kindly let us know the above information since this detail require for
> an internal auditing purpose.
>
> Thanks.
>
> */Warm regards,/**/
>
> M Sonai Muthu Raja


--
Adrian Klaver
adrian.kla...@aklaver.com
DISCLAIMER: The information contained in this electronic message and any 
attachments to this message are intended for the exclusive use of the 
addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended recipient, you should not disseminate, 
distribute or copy this e-mail. Please notify the sender immediately and 
destroy all copies of this message and any attachments. Please note that 
intercepting or any unauthorized use of this message or any attachment can be 
treated as infringement of person’s right of privacy under the Human Rights Act 
1993 and also is a Criminal Offence under the Information and Technology Act, 
2008.

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email. Thank you for your cooperation.

Re: Require details that how to find user creation date in postgresql Database

[Sonai muthu raja M]

Dear Team,

Kindly help us to provide the details that how to find User creation date in 
postgresql Database.

Note: we know that we can find the create user query from postgresql log. Apart 
from that how to find it from inside the Database

Warm regards,

M Sonai Muthu Raja
Managed Delivery Services - DBA Support
M: +919003132734
II Floor, TIDEL Park, 4 Rajiv Gandhi Salai,
Taramani, Chennai – 600 113

[cid:01b1fe56-bb1a-41e1-958c-289acbc17f49]

www.sifytechnologies.com<http://www.sifytechnologies.com>



From: Sonai muthu raja M 
Sent: Thursday, December 2, 2021 2:54 PM
To: secur...@postgresql.org 
Cc: Sonai muthu raja M 
Subject: Require details that how to find user creation date in postgresql 
Database

Dear Team,

Kindly help us to provide the details that how to find User creation date in 
postgresql Database.

Note: we know that we can find the create user query from postgresql log. Apart 
from that how to find it from inside the Database.

Warm regards,

M Sonai Muthu Raja
Managed Delivery Services - DBA Support
M: +919003132734
II Floor, TIDEL Park, 4 Rajiv Gandhi Salai,
Taramani, Chennai – 600 113

[cid:b274d046-b74a-4a8f-9bfd-b145ae0303c9]

www.sifytechnologies.com<http://www.sifytechnologies.com>


DISCLAIMER: The information contained in this electronic message and any 
attachments to this message are intended for the exclusive use of the 
addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended recipient, you should not disseminate, 
distribute or copy this e-mail. Please notify the sender immediately and 
destroy all copies of this message and any attachments. Please note that 
intercepting or any unauthorized use of this message or any attachment can be 
treated as infringement of person’s right of privacy under the Human Rights Act 
1993 and also is a Criminal Offence under the Information and Technology Act, 
2008.

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email. Thank you for your cooperation.

Re: Require details that how to find user creation date in postgresql Database

[Sonai muthu raja M]

Dear Tom,

Thank you so much for sharing the information.



Regards,

M. Sonai Muthu Raja

Managed Delivery Services - DBA Support

Landline - 044 66235600, Extn - 1176​

Mobile - +91 9003132734






From: Tom Lane 
Sent: Friday, December 3, 2021 3:51 AM
To: Sonai muthu raja M 
Cc: pgsql-general@lists.postgresql.org 
Subject: Re: Require details that how to find user creation date in postgresql 
Database

WARNING: This email originated from outside of Sify domain. DO NOT click the 
links or open the attachments unless you recognize the sender and know the 
content is safe.



"Sonai muthu raja  M"  writes:
> Kindly help us to provide the details that how to find User creation date in 
> postgresql Database.

This information is not stored by Postgres, so you can't.

regards, tom lane
DISCLAIMER: The information contained in this electronic message and any 
attachments to this message are intended for the exclusive use of the 
addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended recipient, you should not disseminate, 
distribute or copy this e-mail. Please notify the sender immediately and 
destroy all copies of this message and any attachments. Please note that 
intercepting or any unauthorized use of this message or any attachment can be 
treated as infringement of person’s right of privacy under the Human Rights Act 
1993 and also is a Criminal Offence under the Information and Technology Act, 
2008.

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email. Thank you for your cooperation.

Require details that can we set characters length of a password to a User account in PostgreSQL Database.

[Sonai muthu raja M]

Dear Team,

Kindly help us to know that can we set characters length of a password to a 
User account in PostgreSQL Database.

Please do the needful since the information require for auditing purpose.



Warm regards,

M Sonai Muthu Raja
Managed Delivery Services - DBA Support
M: +919003132734
II Floor, TIDEL Park, 4 Rajiv Gandhi Salai,
Taramani, Chennai – 600 113

[cid:a3540352-d107-4544-a5d0-a5590962bea4]

www.sifytechnologies.com<http://www.sifytechnologies.com>



From: Sonai muthu raja M 
Sent: Thursday, December 2, 2021 3:21 PM
To: pgsql-general@lists.postgresql.org 
Cc: Sonai muthu raja M 
Subject: Re: Require details that how to find user creation date in postgresql 
Database

Dear Team,

Kindly help us to provide the details that how to find User creation date in 
postgresql Database.

Note: we know that we can find the create user query from postgresql log. Apart 
from that how to find it from inside the Database

Warm regards,

M Sonai Muthu Raja
Managed Delivery Services - DBA Support
M: +919003132734
II Floor, TIDEL Park, 4 Rajiv Gandhi Salai,
Taramani, Chennai – 600 113

[cid:01b1fe56-bb1a-41e1-958c-289acbc17f49]

www.sifytechnologies.com<http://www.sifytechnologies.com>


____
From: Sonai muthu raja M 
Sent: Thursday, December 2, 2021 2:54 PM
To: secur...@postgresql.org 
Cc: Sonai muthu raja M 
Subject: Require details that how to find user creation date in postgresql 
Database

Dear Team,

Kindly help us to provide the details that how to find User creation date in 
postgresql Database.

Note: we know that we can find the create user query from postgresql log. Apart 
from that how to find it from inside the Database.

Warm regards,

M Sonai Muthu Raja
Managed Delivery Services - DBA Support
M: +919003132734
II Floor, TIDEL Park, 4 Rajiv Gandhi Salai,
Taramani, Chennai – 600 113

[cid:b274d046-b74a-4a8f-9bfd-b145ae0303c9]

www.sifytechnologies.com<http://www.sifytechnologies.com>


DISCLAIMER: The information contained in this electronic message and any 
attachments to this message are intended for the exclusive use of the 
addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended recipient, you should not disseminate, 
distribute or copy this e-mail. Please notify the sender immediately and 
destroy all copies of this message and any attachments. Please note that 
intercepting or any unauthorized use of this message or any attachment can be 
treated as infringement of person’s right of privacy under the Human Rights Act 
1993 and also is a Criminal Offence under the Information and Technology Act, 
2008.

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email. Thank you for your cooperation.

Re: Require details that can we set characters length of a password to a User account in PostgreSQL Database.

[Sonai muthu raja M]

Hi Laurenz,

Thank you so much for the information.

Warm regards,

M Sonai Muthu Raja
Managed Delivery Services - DBA Support
M: +919003132734
II Floor, TIDEL Park, 4 Rajiv Gandhi Salai,
Taramani, Chennai – 600 113

[cid:a257a70b-14af-48c0-b44f-ded59799455e]

www.sifytechnologies.com<http://www.sifytechnologies.com>



From: Laurenz Albe 
Sent: Tuesday, March 1, 2022 5:19 PM
To: Sonai muthu raja M ; 
pgsql-general@lists.postgresql.org 
Cc: Sivaprahasam Dharman 
Subject: Re: Require details that can we set characters length of a password to 
a User account in PostgreSQL Database.

WARNING: This email originated from outside of Sify domain. DO NOT click the 
links or open the attachments unless you recognize the sender and know the 
content is safe.



On Tue, 2022-03-01 at 08:18 +, Sonai muthu raja  M wrote:
> Kindly help us to know that can we set characters length of a password to a 
> User account in PostgreSQL Database.
>
> Please do the needful since the information require for auditing purpose.

There is no way to do that.

You can use the "passwordcheck" extension, but that will only work for 
clear-text
passwords.

Your only real option is *not* to use passwords in the database, but to 
authenticate
with an external service like Kerberos or LDAP.  Then you can enforce the 
password
rules there.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

DISCLAIMER: The information contained in this electronic message and any 
attachments to this message are intended for the exclusive use of the 
addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended recipient, you should not disseminate, 
distribute or copy this e-mail. Please notify the sender immediately and 
destroy all copies of this message and any attachments. Please note that 
intercepting or any unauthorized use of this message or any attachment can be 
treated as infringement of person’s right of privacy under the Human Rights Act 
1993 and also is a Criminal Offence under the Information and Technology Act, 
2008.

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email. Thank you for your cooperation.