From: | Michael Rau <michael(dot)rau(at)iqundu(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: ALTER DEFAULT PRIVs / not working for me |
Date: | 2010-11-16 22:18:32 |
Message-ID: | 201011162318.32893.michael.rau@iqundu.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | A B | 2010-11-17 07:46:41 | How to detect if any rows were returned in plpgsql function? |
Previous Message | Tom Lane | 2010-11-16 18:06:51 | Re: ALTER DEFAULT PRIVs / not working for me |