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

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: How to set an expiration date for a WHOLE user account
Дата
Msg-id d8oc7n$2kft$1@news.hub.org
обсуждение исходный текст
Ответ на 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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
"Egy�d Csaba" <csegyud@vnet.hu> 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 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.

Regards,
Qingqing



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

Предыдущее
От: go
Дата:
Сообщение: Database became very slow(Help PLS)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to set an expiration date for a WHOLE user account