Stephen Frost <sfrost@snowman.net> writes:
> create role admin with noinherit;
> grant postgres to admin;
> grant admin to joesysadmin;
> pg_dump -U joesysadmin mydb;
> Fails because joesysadmin hasn't got rights to everything directly.
Seems like the correct answer to that is "use a saner role
configuration".
regards, tom lane