Re: ALTER DEFAULT PRIVs / not working for me

Tom, this clarified things for me. Thanks very much for your support.

Michael.

Am Dienstag, 16. November 2010, um 19:06:51 schrieb Tom Lane:
> 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