On Tue, Mar 23, 2010 at 1:28 PM, Josh Berkus <j...@agliodbs.com> wrote: > I don't think that the idea of turning on the jail mode via a > session-level switch works, given the realities of connection pooling. > Also, I do not believe that we currently have any USERSET variable which > can be turned on but not off, so that would require adding a whole new mode.
I think this could be done with an assign hook. > BTW, if you wanted something less ambitious, we have a longstanding > request to implement "local superuser", that is, the ability to give one > role the ability to edit other roles in one database only. But roles aren't database-specific... they're globals. ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers