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

Поиск
Список
Период
Сортировка
От Zlatko Matić
Тема Re: How to set an expiration date for a WHOLE user account
Дата
Msg-id 00b301c5719e$38440340$d4211dc3@zlatkovyfkpgz6
обсуждение исходный текст
Ответ на How to set an expiration date for a WHOLE user account  (Együd Csaba <csegyud@vnet.hu>)
Ответы Re: How to set an expiration date for a WHOLE user account  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: Deadlock Problem
Следующее
От: Changyu Dong
Дата:
Сообщение: Re: Best approach setting up PostgreSQL