X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AC1248B9EDC for ; Thu, 10 Feb 2005 20:36:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 97315-08 for ; Thu, 10 Feb 2005 20:35:53 +0000 (GMT) Received: from 9.hellooperator.net (cpc3-cdif2-3-0-cust202.cdif.cable.ntl.com [81.103.32.202]) by svr1.postgresql.org (Postfix) with ESMTP id 5D5C18B9EEB for ; Thu, 10 Feb 2005 20:35:53 +0000 (GMT) Received: from [10.4.0.5] (helo=eris.tenfour) by 9.hellooperator.net with esmtp (Exim 4.43) id 1CzL2W-0006oK-FA; Thu, 10 Feb 2005 20:35:53 +0000 Received: from rasputnik by eris.tenfour with local (Exim 4.44 (FreeBSD)) id 1CzL2W-000DJW-A5; Thu, 10 Feb 2005 20:35:52 +0000 Date: Thu, 10 Feb 2005 20:35:52 +0000 From: Dick Davies To: Tom Lane Cc: PostgreSQL Admin Subject: Re: removing create database privileges? Message-ID: <20050210203551.GD35853@eris.tenfour> Reply-To: Dick Davies References: <20050210201354.GC35853@eris.tenfour> <1924.1108067509@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1924.1108067509@sss.pgh.pa.us> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.557 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: * X-Archive-Number: 200502/90 X-Sequence-Number: 16258 * Tom Lane [0231 20:31]: > Dick Davies writes: > > I'm probably missing something obvious, but how do I revoke the 'create database' > > privilege for a user? > > See ALTER USER. Thanks Tom. As usual I found it 15 seconds after posting :) -- 'Power corrupts. Absolute power - is kind of neat.' -- John Lehman, Secretary of the Navy, 1981-1987 Rasputin :: Jack of All Trades - Master of Nuns