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@xxxxxxxxxxxxx>
To: "Qingqing Zhou" <zhouqq@xxxxxxxxxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, June 15, 2005 7:08 AM
Subject: Re: How to set an expiration date for a WHOLE user
account
"Qingqing Zhou" <zhouqq@xxxxxxxxxxxxxx> writes:
"Együd Csaba" <csegyud@xxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
