From: | Erwin Brandstetter <brsaweda(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: DEFAULT PRIVILEGES incorrect |
Date: | 2016-02-10 04:23:07 |
Message-ID: | CAGHENJ78GVyYS-uhzB5d0Y_48so0GKNqEiCPTLTe56XHYb8NWA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2016-02-10 09:33:42 | Re: DEFAULT PRIVILEGES incorrect |
Previous Message | Gabriel E. Sánchez Martínez | 2016-02-09 16:13:15 | Re: Copy & paste key commands not working correctly |