Re: How to set an expiration date for a WHOLE user account - Mailing list pgsql-general

From Qingqing Zhou
Subject Re: How to set an expiration date for a WHOLE user account
Date
Msg-id d8oc7n$2kft$1@news.hub.org
Whole thread Raw
In response to How to set an expiration date for a WHOLE user account  (Együd Csaba <csegyud@vnet.hu>)
Responses Re: How to set an expiration date for a WHOLE user account  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
"Egy�d Csaba" <csegyud@vnet.hu> writes
>
> I'm wonder how I can disable a user (without droping of course). Is there
a
> way to set an expiration date to prevent logins after that date?
>
> I know the VALID UNTIL clause of CREATE USER command, but it is about the
> password only.
> I think something similar but regarding the whole user account.
>

It is not about password only. Once current date is beyond the valid date
you set, the user can never get authorized ok anymore.

Regards,
Qingqing



pgsql-general by date:

Previous
From: go
Date:
Subject: Database became very slow(Help PLS)
Next
From: Tom Lane
Date:
Subject: Re: How to set an expiration date for a WHOLE user account