I want a query which tells me which user granted a role to another user in my Postgres database. Expected output would be as follows:
SELECT role, grantor, grantee, grant_date FROM information_schema.<table>; role grantor grantee grant_date grp_db_admin Tom Dwan Eli Elezra 2019-09-09 ........ grp_db_viewer Viktor Blom Patrick Antonius 2019-08-02
So far I've found the
pg_catalog.pg_roles tables, however these don't allow me to see who it was that granted someone a role group.
Any help would be appreciated.