From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Allen, Mike" <Mike(dot)Allen(at)durrusa(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: New group roles always inherit privileges... |
Date: | 2005-11-04 17:15:34 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC3959@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
________________________________
From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Allen, Mike
Sent: 04 November 2005 17:00
To: pgadmin-support(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2005-11-05 13:09:52 | Tabs in query editing window |
Previous Message | Allen, Mike | 2005-11-04 16:59:41 | New group roles always inherit privileges... |