Re: superusers are members of all roles? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: superusers are members of all roles?
Date
Msg-id 13051.1302188479@sss.pgh.pa.us
Whole thread Raw
In response to Re: superusers are members of all roles?  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: superusers are members of all roles?  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> I thought about that. What I'd like to know is how many people actually 
> want and use and expect the current behaviour. If it's more than a 
> handful (which I seriously doubt) then that's probably the way to go. 
> Otherwise it seems more trouble than it's worth.

Well, the point here is that "is_member_of" is currently considered
to be a kind of privilege test, and of course superusers should
automatically pass every privilege test.  If you want it to not act
that way in some circumstances, we need a fairly clear theory as to
which circumstances it should act which way in.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [BUGS] Failed assert ((data - start) == data_size) in heaptuple.c
Next
From: "Kevin Grittner"
Date:
Subject: Re: SSI bug?