Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
"Sonai muthu raja M"
Date:
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




From: Sonai muthu raja M <Sonaimuthu.Raja@sifycorp.Com>
Sent: Thursday, December 2, 2021 2:54 PM
To: security@postgresql.org <security@postgresql.org>
Cc: Sonai muthu raja M <Sonaimuthu.Raja@sifycorp.Com>
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



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.
Attachment

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

From
Tom Lane
Date:
"Sonai muthu raja  M" <Sonaimuthu.Raja@sifycorp.Com> 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

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

From
Adrian Klaver
Date:
On 12/2/21 01:51, Sonai muthu raja M wrote:
> 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

You can't.

> 
> */Warm regards,/**/
> 
> M Sonai Muthu Raja
> Managed Delivery Services - DBA Support

-- 
Adrian Klaver
adrian.klaver@aklaver.com

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

From
"Sonai muthu raja M"
Date:
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 <tgl@sss.pgh.pa.us>
Sent: Friday, December 3, 2021 3:51 AM
To: Sonai muthu raja M <Sonaimuthu.Raja@sifycorp.Com>
Cc: pgsql-general@lists.postgresql.org <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" <Sonaimuthu.Raja@sifycorp.Com> 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.

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

From
Achilleas Mantzios
Date:
On 2/12/21 11:51 π.μ., Sonai muthu raja M wrote:
P {margin-top:0;margin-bottom:0;}
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
Till the next freeze (normal, explicit or emergency) and provided track_commit_timestamp is set to on, you can use this :

dynacom=# create role nuzer;
CREATE ROLE
dynacom=# select pg_xact_commit_timestamp(xmin) from pg_authid where rolname = 'nuzer';
   pg_xact_commit_timestamp   
-------------------------------
 2021-12-03 14:35:09.163502+02
(1 row)



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




From: Sonai muthu raja M <Sonaimuthu.Raja@sifycorp.Com>
Sent: Thursday, December 2, 2021 2:54 PM
To: security@postgresql.org <security@postgresql.org>
Cc: Sonai muthu raja M <Sonaimuthu.Raja@sifycorp.Com>
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



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. 


-- 
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
Attachment

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

From
"Sonai muthu raja M"
Date:
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



From: Sonai muthu raja M <Sonaimuthu.Raja@sifycorp.Com>
Sent: Thursday, December 2, 2021 3:21 PM
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Cc: Sonai muthu raja M <Sonaimuthu.Raja@sifycorp.Com>
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




From: Sonai muthu raja M <Sonaimuthu.Raja@sifycorp.Com>
Sent: Thursday, December 2, 2021 2:54 PM
To: security@postgresql.org <security@postgresql.org>
Cc: Sonai muthu raja M <Sonaimuthu.Raja@sifycorp.Com>
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



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.
Attachment

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

From
Laurenz Albe
Date:
On Tue, 2022-03-01 at 08:18 +0000, 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

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

From
"Sonai muthu raja M"
Date:
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



From: Laurenz Albe <laurenz.albe@cybertec.at>
Sent: Tuesday, March 1, 2022 5:19 PM
To: Sonai muthu raja M <Sonaimuthu.Raja@sifycorp.Com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Cc: Sivaprahasam Dharman <Sivaprahasam.Dharman@sifycorp.Com>
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 +0000, 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.
Attachment