database role create date

Поиск
Список
Период
Сортировка
От Михаил
Тема database role create date
Дата
Msg-id 1423820747.162934956@f123.i.mail.ru
обсуждение исходный текст
Список pgsql-admin
Hi,
Is there a way to get database role create date?

The issue is: i have a bunch of tables owner by user trololo and i have a user trololo_rw, which according to the scripts should have dml-grants on them, but do not actually have. I have an assumption that someone recreated user troololo_rw. So, I know that creation datetime of trololo_rw user should be "2015-01-20 13:38:22.66078" and to confirm / refute my assumptions I am missing the real creation date.

Regards, Mikhail

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

Предыдущее
От: Dave Johansen
Дата:
Сообщение: Re: Postgres 8.4.20 seqfault on RHEL 6.4
Следующее
От: Михаил
Дата:
Сообщение: Re[2]: [ADMIN] getting client_addr not as a superuser