Re: How to set an expiration date for a WHOLE user account

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to set an expiration date for a WHOLE user account
Date: 2005-06-15 04:51:03
Message-ID: d8oc7n$2kft$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Egyd Csaba" <csegyud(at)vnet(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-06-15 05:08:58 Re: How to set an expiration date for a WHOLE user account
Previous Message go 2005-06-15 03:55:11 Database became very slow(Help PLS)