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

2005-06-16 Thread Qingqing Zhou
"Tom Lane" <[EMAIL PROTECTED]> writes: > > 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. > If we add a "VALID UNTIL" column in pg_hba.

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

2005-06-15 Thread Bruno Wolff III
On Wed, Jun 15, 2005 at 13:34:39 +0200, Zlatko Mati? <[EMAIL PROTECTED]> wrote: > 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

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

2005-06-15 Thread Zlatko Matić
e any way to acomplish that? Greetings, Zlatko - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Qingqing Zhou" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, June 15, 2005 7:08 AM Subject: Re: [GENERAL] How to set an expiration date for a WHOLE user

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

2005-06-14 Thread Tom Lane
"Qingqing Zhou" <[EMAIL PROTECTED]> writes: > "Együd Csaba" <[EMAIL PROTECTED]> 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 dat

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

2005-06-14 Thread Qingqing Zhou
"Együd Csaba" <[EMAIL PROTECTED]> 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 somet

[GENERAL] How to set an expiration date for a WHOLE user account

2005-06-14 Thread Együd Csaba
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.