Thread: pgAdmin III does not display Default Privileges for schemas
Windows 7 x64
PostgreSQL 9.2.2pgAdmin 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.
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.
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
<div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif">Hello,</div><div class="gmail_default" style="font-family:tahoma,sans-serif"><br/></div><div class="gmail_default" style="font-family:tahoma,sans-serif"> I foundthis thread from 2012 concerning a problem where pgAdmin III doesn't display default privileges for schemas:</div><divclass="gmail_default" style="font-family:tahoma,sans-serif"><br /></div><div class="gmail_default"><fontface="tahoma, sans-serif"><a href="http://www.postgresql.org/message-id/1356354218.2000.30.camel@localhost.localdomain">http://www.postgresql.org/message-id/1356354218.2000.30.camel@localhost.localdomain</a></font><br /></div><divclass="gmail_default"><font face="tahoma, sans-serif"><br /></font></div><div class="gmail_default"><font face="tahoma,sans-serif">The thread says the fix has been made, but I just downloaded the latest Windo</font>ws version (v1.18.1) of pgAdmin III and the problem still seems to be happening. Is the fix not available in this version?</div><divclass="gmail_default"><br />On Fri, 2012-12-07 at 20:38 -0600, Nathan Alden wrote:<br /><br />> Windows7 x64<br />> PostgreSQL 9.2.2<br />> pgAdmin III 1.16.1<br />> <br />> Follow these steps to reproduce:<br/>> <br /> > 1. Connect to the postgres DB.<br />> 2. Run the following SQL:<br />> <br />> createdatabase test_database;<br />> <br />> 3. Run the following SQL:<br />> <br />> create role my_group;<br/>> <br />> 4. Connect to the test_database DB.<br /> > 5. Run the following SQL:<br />> <br />>alter default privileges in schema public grant all on types to my_group;<br />> <br />> 6. Open pgAdmin III.<br/>> 7. Navigate to the public schema in test_database.<br /> > 8. Right-click the public schema and choose Properties.<br/>> 9. Select the Default Privileges tab.<br />> 10. Note that all four subtabs are empty, and the Roledrop-down lists do<br />> not list my_group as a role.<br /> ><br />> Thanks for your report, it's fixed now.<br/>><br />><br />>-- <br />>Guillaume<br />><a href="http://blog.guillaume.lelarge.info">http://blog.guillaume.lelarge.info</a><br/>><a href="http://www.dalibo.com">http://www.dalibo.com</a><br/><br />Thank you,</div><div class="gmail_default">Shira<br /><divstyle="font-weight:bold;font-style:normal;font-variant:normal;line-height:20px;margin:0px"><br style="color:rgb(0,0,0);font-family:Tahoma;font-size:13px;font-weight:normal;line-height:normal"/></div><div style="font-weight:bold;font-style:normal;font-variant:normal;line-height:20px;margin:0px"><br/></div><div style="padding-top:8px"> </div></div></div>
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
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?
Shira
On Thu, Feb 13, 2014 at 12:54 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote:
On Thu, 2014-02-13 at 12:40 -0800, Shira Bezalel wrote:It should.
> 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?
>
> 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
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@lelarge.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
On Thu, 2014-02-13 at 14:10 -0800, Shira Bezalel wrote: > On Thu, Feb 13, 2014 at 1:56 PM, Guillaume Lelarge > <guillaume@lelarge.info>wrote: > > > 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. > > > > I apologize for the top-posting. Didn't mean to do that. > No problem. And please, keep the list posted :) > Can you tell me specifically which option you are referring to? If you mean > Options > Browser > Display > Users/login Roles, then yes, it is checked. > No, I meant Options > Browser > UI Miscellaneous > Show users for privileges. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
On Thu, Feb 13, 2014 at 2:15 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote:
On Thu, 2014-02-13 at 14:10 -0800, Shira Bezalel wrote:No problem. And please, keep the list posted :)
> On Thu, Feb 13, 2014 at 1:56 PM, Guillaume Lelarge
> <guillaume@lelarge.info>wrote:
>
> > 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.
> >
>
> I apologize for the top-posting. Didn't mean to do that.
>No, I meant Options > Browser > UI Miscellaneous > Show users for
> Can you tell me specifically which option you are referring to? If you mean
> Options > Browser > Display > Users/login Roles, then yes, it is checked.
>
privileges.
Many thanks Guillaume! Turning on that option took care of it.
Shira