From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: DROP ROLE dependency tracking ... |
Date: | 2008-12-16 11:48:37 |
Message-ID: | 20081216114837.GC4741@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Bruce Momjian wrote:
> Alvaro Herrera wrote:
> > Hans-Juergen Schoenig wrote:
> >
> > > when thinking of REASSIGNED OWNED people tend to think about tables
> > > rather than about CONNECT rights.
> > > i would suggest to make DROP ROLE just kill the role unless there is a
> > > real object depending on it.
> > > i would not see a permission to be an object. what do you think?
> >
> > Yes, this might make some sense. (Keep in mind that db CONNECT
> > privileges were invented after REASSIGN OWNED). Perhaps we could make
> > exceptions -- in which case it would be good to investigate which
> > exceptions we need (i.e. for all object types that we support, which
> > ones we should be caring about and which ones we should ignore).
> >
> > I'm stuck in Canuckistan for a week still, so I expect your detailed
> > proposal by when I get back home ;-)
>
> Was there any progress on this?
Not from my side --- and Hans-Juergen never got back to me either ...
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2008-12-16 12:05:43 | Re: Function with defval returns error |
Previous Message | Peter Eisentraut | 2008-12-16 11:08:44 | Re: DTrace probes patch |