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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers