Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9F2F29FB2D4 for ; Thu, 16 Aug 2007 12:41:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 65947-01 for ; Thu, 16 Aug 2007 12:41:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id 73B349FB572 for ; Thu, 16 Aug 2007 12:41:03 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so304794ugf for ; Thu, 16 Aug 2007 08:41:02 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=h/HdRYkY8Nmx6iwkTGTUGnc1dPnKLzUVEkRfP2ptEe7ZCVvM8Y9lolaq3GOtPQSR4XHpLEcQF+xBXtuTTAy/5Osel5RLzq5FW/ryS5VCsgZIx2bqssebJRyB4CBv1AQWR3eUVLl4dwwUXGU1fyTin2dIo6KSLPp5MA02I3ymCkM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=WBy4jcKqRBl3K6juD3HzrjbA1GKk40NcOLzdty1ZxMYbF4PxQdQTY7iylWMfsP4D2p0c/k/P8jRNwMwFFSPM8rAbZ6YKQuoTu7JJY+qohB/9rBt1M2bouCj9wEM5JlB5It6D3wcbM2bDkoTBWayjLrSyF1JLlnIDaxRNhVSHU7Q= Received: by 10.142.111.14 with SMTP id j14mr113212wfc.1187278860526; Thu, 16 Aug 2007 08:41:00 -0700 (PDT) Received: by 10.143.31.14 with HTTP; Thu, 16 Aug 2007 08:41:00 -0700 (PDT) Message-ID: Date: Thu, 16 Aug 2007 10:41:00 -0500 From: "=?UTF-8?Q?Rodrigo_De_Le=C3=B3n?=" To: Joshua_Kramer Subject: Re: SUPERUSER vs CREATEUSER causes foul 'code smell' Cc: pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/144 X-Sequence-Number: 29082 On 8/16/07, Joshua_Kramer wrote: > In the pg_users view - is there a way to differentiate between a role with > SUPERUSER priveleges, and a user who merely has the CREATEUSER flag? select * from pg_roles; > If I want to create a role who can create other roles, but not have other > SUPERUSER priveleges - how can I do that? create role foo createrole login password 'foo'; See: http://www.postgresql.org/docs/8.2/static/sql-createrole.html