Michael Rau <michael(dot)rau(at)iqundu(dot)com> writes:
> I am very excited about the new features of 9.0 to ALTER DEFAULT PRIVILEGES.
> But I cannot get it working. What am I doing wrong?
I think you misunderstand this:
> test=# alter default privileges for role iquser GRANT ALL ON TABLES to iquser;
That says to change the default privileges for tables that are
subsequently created by role iquser. It does not apply to tables
created by any other role. In particular it does not recursively
apply to roles that happen to be a member of the group iquser.
regards, tom lane