Stephen Frost <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
