Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 52A14B5DC51 for ; Tue, 18 Oct 2011 18:04:00 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 77331-01 for ; Tue, 18 Oct 2011 21:03:53 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id CCCAAB5DC1E for ; Tue, 18 Oct 2011 18:03:52 -0300 (ADT) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Tue, 18 Oct 2011 16:03:52 -0500 Message-Id: <4E9DA36202000025000421E7@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Tue, 18 Oct 2011 16:03:46 -0500 From: "Kevin Grittner" To: "Alexander James Spence [axs]" , "'pgsql-admin@postgresql.org'" Subject: Re: Privileges question References: <8EDB6E83019BEC4B9153122CFB928AF001F6463C4B5D@MAILBOX.staff.aber.ac.uk> <4E9D628A0200002500042183@gw.wicourts.gov> <8EDB6E83019BEC4B9153122CFB928AF001F6463C4B84@MAILBOX.staff.aber.ac.uk> In-Reply-To: <8EDB6E83019BEC4B9153122CFB928AF001F6463C4B84@MAILBOX.staff.aber.ac.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.404 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201110/91 X-Sequence-Number: 38543 "Alexander James Spence [axs]" wrote: > If I wanted to set this as a default for all new databases and > users how/where do I alter/create a schema other than public? You could do the REVOKEs against the template1 database (or whatever database you use for creating these if you don't take the default). The rest would need to be scripted, so I would probably just leave the template alone and cover the whole thing in my script. -Kevin