database role create date

From: Михаил <bemewe(at)mail(dot)ru>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: database role create date
Date: 2015-02-13 09:45:47
Message-ID: 1423820747.162934956@f123.i.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Михаил 2015-02-13 10:58:35 Re[2]: [ADMIN] getting client_addr not as a superuser
Previous Message Dave Johansen 2015-02-13 05:25:32 Re: Postgres 8.4.20 seqfault on RHEL 6.4