7.4 Alter User xxx VALID UNTIL '2000-01-01' does not work

Поиск
Список
Период
Сортировка
От ezra epstein
Тема 7.4 Alter User xxx VALID UNTIL '2000-01-01' does not work
Дата
Msg-id aiKdncTpIY1OHWiiXTWc-g@speakeasy.net
обсуждение исходный текст
Список pgsql-general
I'm trying to keep a user around but make it invalid.  E.g., by setting the
valid until to be a time in the past.  I've tried this:

    alter user pw_config valid until 'Jan 31 2001';

and this:

   alter user pw_config valid until '2000-01-01';

and even this:

    alter user pw_config valid until '-infinity';  -- for good measure

and none of them seems to have an affect.  The field is changed (pg_admin
says so) but psql still lets the user connect and execute statements.

Help!

  == Ezra Epstein



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

Предыдущее
От: "ezra epstein"
Дата:
Сообщение: Re: 7.4 ERROR: CREATE LOCAL TEMPORARY TABLE ... ON COMMIT DROP inside a function
Следующее
От: "ezra epstein"
Дата:
Сообщение: Any way to have CREATEUSER privs without having all privs?