Re: superusers are members of all roles?
From:
Andrew Dunstan <andrew(at)dunslane(dot)net>
To:
Bruce Momjian <bruce(at)momjian(dot)us>
Cc:
Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,
pgsql-hackers(at)postgresql(dot)org
Subject:
Re: superusers are members of all roles?
Date:
2011-09-12 01:40:13
Message-ID:
4E6D62FD.4070908@dunslane.net (view raw or flat )
Thread:
2011-04-06 23:04:42 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-04-06 23:54:06 from Stephen Frost <sfrost(at)snowman(dot)net>
2011-04-07 03:54:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-04-07 04:21:58 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-04-07 04:29:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-04-07 04:45:48 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-04-07 04:49:02 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-04-07 07:48:36 from Alastair Turner <bell(at)ctrlf5(dot)co(dot)za>
2011-04-07 10:33:08 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-04-07 11:33:48 from Christian Ullrich <chris(at)chrullrich(dot)net>
2011-04-07 12:01:16 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-04-07 15:01:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-04-07 15:26:29 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-05-08 03:42:57 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-05-09 11:53:50 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-09-10 03:34:45 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-09-12 01:40:13 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-09-12 02:32:07 from Stephen Frost <sfrost(at)snowman(dot)net>
2011-09-12 03:27:40 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-09-12 03:29:59 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-09-12 09:55:42 from Stephen Frost <sfrost(at)snowman(dot)net>
2011-11-02 19:27:28 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-11-03 01:41:44 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-04-07 14:14:39 from Stephen Frost <sfrost(at)snowman(dot)net>
Lists:
pgsql-hackers
On 09/09/2011 11:34 PM, Bruce Momjian wrote:
> Robert Haas wrote:
>> On Sat, May 7, 2011 at 11:42 PM, Bruce Momjian<bruce(at)momjian(dot)us> wrote:
>>> Is this a TODO?
>> I think so.
> Added to TODO:
>
> Address problem where superusers are assumed to be members of all groups
>
> http://archives.postgresql.org/pgsql-hackers/2011-04/msg00337.php
This turns out to be a one-liner.
Patch attached.
cheers
andrew
In response to
Responses
pgsql-hackers by date
Next :From: Stephen FrostDate: 2011-09-12 02:32:07
Subject : Re: superusers are members of all roles?
Previous :From : Tom LaneDate : 2011-09-11 21:22:26
Subject : Re: [WIP] Caching constant stable expressions per execution