Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-bugs(at)postgresql(dot)org, mr-russ(at)pws(dot)com(dot)au, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)
Date: 2007-05-04 21:31:50
Message-ID: 10924.1178314310@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Stephen Frost <sfrost(at)snowman(dot)net> writes:
> Hmm. I'm not sure, but that may have been a case where it was generally
> decided that the spec was somewhat braindead in this fashion (it seems
> so in my personal view of this, honestly...). To issue a revoke and
> have it not work would be kind of concerning. If we do end up following
> this path we should emit a warning (at least...) if the user still has
> the rights which are being revoked, even if through someone else.

That's not how it works for rights on ordinary objects.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ennio-Sr 2007-05-04 21:52:18 Re: order by question.
Previous Message Stephen Frost 2007-05-04 20:54:07 Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-05-04 21:39:25 Re: [COMMITTERS] pgsql: Teach tuplesort.c about "top N" sorting, in which only the first
Previous Message Stephen Frost 2007-05-04 20:54:07 Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)