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

Hi.
Concerning Együd's question, I also wanted to ask about setting expiration
date for database. But, I would like to set validity in sense of certain
actions.
For example, I would like to prevent adding new records after expiration,
but would allow viewing existing records....
Is there any way to acomplish that?
Greetings,
Zlatko

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Qingqing Zhou" <zhouqq@cs.toronto.edu>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, June 15, 2005 7:08 AM
Subject: Re: [GENERAL] How to set an expiration date for a WHOLE user
account


> "Qingqing Zhou" <zhouqq@cs.toronto.edu> writes:
>> "Együd Csaba" <csegyud@vnet.hu> writes
>>> 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.
>
> He's right, you're not: that check is only applied in the
> password-based authorization path.
>
> This has always seemed a bit bogus to me too --- would not object to
> a well-thought-out patch to change it.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match