How to set an expiration date for a WHOLE user account

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: How to set an expiration date for a WHOLE user account
Date: 2005-06-14 19:37:31
Message-ID: 0II30043JAIJ54@mail.vnet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
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.

Thanks,
-- Csaba Együd

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.9 - Release Date: 2005.06.11.

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.9 - Release Date: 2005.06.11.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2005-06-14 20:18:15 Re: Hash Function: MD5 or other?
Previous Message Igor Katrayev 2005-06-14 19:27:30 Re: Set Membership operator -- test group membership