Re: pgAdmin III does not display Default Privileges for schemas

On Thu, 2014-02-13 at 13:26 -0800, Shira Bezalel wrote:
> Okay, you're right. Sorry about that -- that exact test case is working,
> however, other default privileges I've modified aren't showing up. The
> common denominator seems to be whether the role is a group role or a login
> role. Default privilege changes for login roles don't seem to show up in
> pgAdmin III -- are they supposed to?
>

Yes. Did you allow showing login roles in the options dialog?

And please, don't top-post, it makes it hard to read and follow.

> Shira
>
>
> On Thu, Feb 13, 2014 at 12:54 PM, Guillaume Lelarge
> <guillaume(at)lelarge(dot)info>wrote:
>
> > On Thu, 2014-02-13 at 12:40 -0800, Shira Bezalel wrote:
> > > Hello,
> > >
> > > I found this thread from 2012 concerning a problem where pgAdmin III
> > > doesn't display default privileges for schemas:
> > >
> > >
> > http://www.postgresql.org/message-id/1356354218.2000.30.camel@localhost.localdomain
> > >
> > > The thread says the fix has been made, but I just downloaded the latest
> > > Windows version (v 1.18.1) of pgAdmin III and the problem still seems to
> > be
> > > happening. Is the fix not available in this version?
> > >
> >
> > It should.
> >
> > > On Fri, 2012-12-07 at 20:38 -0600, Nathan Alden wrote:
> > >
> > > > Windows 7 x64
> > > > PostgreSQL 9.2.2
> > > > pgAdmin III 1.16.1
> > > >
> > > > Follow these steps to reproduce:
> > > >
> > > > 1. Connect to the postgres DB.
> > > > 2. Run the following SQL:
> > > >
> > > > create database test_database;
> > > >
> > > > 3. Run the following SQL:
> > > >
> > > > create role my_group;
> > > >
> > > > 4. Connect to the test_database DB.
> > > > 5. Run the following SQL:
> > > >
> > > > alter default privileges in schema public grant all on types to
> > my_group;
> > > >
> > > > 6. Open pgAdmin III.
> > > > 7. Navigate to the public schema in test_database.
> > > > 8. Right-click the public schema and choose Properties.
> > > > 9. Select the Default Privileges tab.
> > > > 10. Note that all four subtabs are empty, and the Role drop-down lists
> > do
> > > > not list my_group as a role.
> > > >
> > > > Thanks for your report, it's fixed now.
> > > >
> > > >
> > > >--
> > > >Guillaume
> > > >http://blog.guillaume.lelarge.info
> > > >http://www.dalibo.com
> > >
> > > Thank you,
> > > Shira
> >
> >
> > --
> > Guillaume
> > http://blog.guillaume.lelarge.info
> > http://www.dalibo.com
> >
> >
>
>

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com