Re: One Role, Two Passwords - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: One Role, Two Passwords
Date
Msg-id 20110121020714.GQ30352@tamriel.snowman.net
Whole thread Raw
In response to Re: One Role, Two Passwords  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: One Role, Two Passwords  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
* Robert Haas (robertmhaas@gmail.com) wrote:
> It strikes me that it would be useful to have a GUC that sets the
> owner of any new objects you create (much as you can control their
> default schemas using search_path).

There was a great deal of discussion along these lines over the summer
of '09 (iirc) with regard to default owners and with the default
privileges patch.  I encourage you to try and make it happen though.

> It's always struck me that using multiple
> database logins would create all sorts of inconsistencies with
> different objects ending up owned by different users, but I guess
> until recently I was under the impression I was the only one who had
> an issue with that.  It seems not.

Uh, no, you're definitely not alone.  It's a huge pain in the ass,
imv.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: REVIEW: EXPLAIN and nfiltered
Next
From: Robert Haas
Date:
Subject: Re: REVIEW: EXPLAIN and nfiltered