Re: New group roles always inherit privileges...

---

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Allen, Mike
Sent: 04 November 2005 17:00
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] New group roles always inherit privileges...

Platform: Windows XP (with SP2)

Language: en-us

Distribution: Windows binary installer

Version: 1.4-rc1

 

To reproduce:

 

1.       Right-click on Group Roles, select “New Group Role”.

2.       New Group Role dialog appears.

3.       Enter “test” for role name, leave all privilege settings cleared & click OK.  Dialog closes, new group role created.

4.       Click on “test” under “Group Roles” (expand latter and refresh if necessary).  Under “Properties” tab in the upper right-hand window frame, you will see “Inherits?” Yes – even though this setting was left cleared when creating the group role.

 

Problem is that, when creating a new group role, the SQL produced is either:

 

CREATE ROLE somegrouprole

   VALID UNTIL ‘infinity’;

 

(if the “Inherits rights from parent roles” Role Privilege is clear) or

 

CREATE ROLE somegrouprole

  INHERIT

   VALID UNTIL ‘infinity’;

 

(if the “Inherits rights from parent roles” Role Privilege is set).

 

The latter is fine, but since PostgreSQL supplies INHERIT as a default, the former should read:

 

CREATE ROLE somegrouprole

  NOINHERIT

   VALID UNTIL ‘infinity’;

 

 

Thanks Mike - fixed in SVN, just in time for release :-)

Regards, Dave