How to find out if a user is granted to pg_write_all_data?

89 Views Asked by Ethan Leroy At 03 April 2025 at 07:03

Starting with PostgreSQL 14 there is a new predefined pg_write_all_data. To add a user to this role we use

GRANT pg_write_all_data TO our_user;

But how can we find out which user we granted this role in the past?

There are 0 best solutions below