Re: dropdb ; createdb equivalent without createdb permission?

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: dropdb ; createdb equivalent without createdb permission?
Date: 2007-07-09 18:53:16
Message-ID: 20070709185316.GD28069@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jul 09, 2007 at 02:50:02PM -0400, Tom Lane wrote:
> A SECURITY DEFINER function (living in some other database of course)
> could accomplish this without going outside Postgres.

Good point. I was originally imagining a sort of scripted QA
environment, and sudo for that sort of thing is pretty useful. But
for other applications, it's probably a lousy choice.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
I remember when computers were frustrating because they *did* exactly what
you told them to. That actually seems sort of quaint now.
--J.D. Baldwin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Olsen 2007-07-09 19:50:33 Re: dropdb ; createdb equivalent without createdb permission?
Previous Message Andrew Sullivan 2007-07-09 18:51:45 Re: dropdb ; createdb equivalent without createdb permission?