From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Erwin Brandstetter <brsaweda(at)gmail(dot)com> |
Cc: | pgAdmin Support <pgadmin-support(at)postgresql(dot)org>, Sanket Mehta <sanket(dot)mehta(at)enterprisedb(dot)com> |
Subject: | Re: DEFAULT PRIVILEGES incorrect |
Date: | 2016-02-10 09:33:42 |
Message-ID: | CA+OCxoyBKGeh-8cfxFKdnpBQePcOjV4wF1LO56hOCocrSe5aQQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Sanket - can you take a look at this when you get a minute please?
Thanks.
On Wed, Feb 10, 2016 at 4:23 AM, Erwin Brandstetter <brsaweda(at)gmail(dot)com> wrote:
> This bug has not been addressed in pgAdmin 1.22.0, yet.
>
> If I run this as user postgres:
>
> ALTER DEFAULT PRIVILEGES FOR ROLE foo IN SCHEMA test
> GRANT SELECT ON TABLES
> TO bar;
>
> Then the SQL pane says (still as user postgres):
>
> ALTER DEFAULT PRIVILEGES IN SCHEMA test
> GRANT SELECT ON TABLES
> TO bar;
>
> Which is incorrect and misleading.
>
> Regards
>
> Erwin
>
> On Thu, Aug 13, 2015 at 2:45 PM, Erwin Brandstetter <brsaweda(at)gmail(dot)com>
> wrote:
>>
>> The display of ALTER DEFAULT PRIVILEGES statements can be incorrect.
>>
>> I reported this bug in 2013, but it seems like it never got through:
>> http://www.postgresql.org/message-id/528C2D00.6010905@falter.at
>>
>> Details, with steps to reproduce:
>> https://redmine.postgresql.org/issues/694
>>
>> Just tested with version 1.20 again and the situation seems unchanged.
>>
>> Regards
>> Erwin
>
>
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Sanket Mehta | 2016-02-10 10:23:08 | Re: DEFAULT PRIVILEGES incorrect |
Previous Message | Erwin Brandstetter | 2016-02-10 04:23:07 | Re: DEFAULT PRIVILEGES incorrect |