Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TlhxS-00072A-DY for pgsql-admin@arkaria.postgresql.org; Thu, 20 Dec 2012 15:22:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TlhxR-0000Gs-8v for pgsql-admin@arkaria.postgresql.org; Thu, 20 Dec 2012 15:22:49 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TlhxQ-0000Gl-5k for pgsql-admin@postgresql.org; Thu, 20 Dec 2012 15:22:48 +0000 Received: from hub.ringways.co.uk ([77.86.27.30] helo=mail.ringways.co.uk) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TlhxL-0003f3-82 for pgsql-admin@postgresql.org; Thu, 20 Dec 2012 15:22:47 +0000 Received: from localhost ([127.0.0.1] helo=mail.ringways.co.uk) by mail.ringways.co.uk with esmtp (Exim 4.69) (envelope-from ) id 1TlhxD-0005xT-EI; Thu, 20 Dec 2012 15:22:36 +0000 Received: from eddie.ringways.co.uk ([10.1.1.115] helo=eddie.ringways.co.uk) by mail.ringways.co.uk with ESMTP id qFMXK8DZ41296; Thu, 20 Dec 2012 15:22:33 +0000 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-admin@postgresql.org Subject: Re: create role? Date: Thu, 20 Dec 2012 15:22:36 +0000 User-Agent: KMail/1.9.10 Cc: Ray Stell References: <202373801.1595767.1356014722327.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> <878C8CCB-BABB-496C-8FFF-ABA921043B3E@vt.edu> In-Reply-To: <878C8CCB-BABB-496C-8FFF-ABA921043B3E@vt.edu> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201212201522.36902.gary.stainburn@ringways.co.uk> X-SpamTest-Envelope-From: gary.stainburn@ringways.co.uk X-SpamTest-Info: Profiles 20401 [Mar 31 2011] X-SpamTest-Method: none X-SpamTest-Rate: 0 X-SpamTest-Status: Not detected X-SpamTest-Status-Extended: not_detected X-SpamTest-Version: SMTP-Filter Version 3.0.0 [0285], KAS30/SDK/Release X-Anti-Virus: Kaspersky Mail Gateway, version: 5.6.28/RELEASE, bases: 20110331T110535 #5151353, check: 20121220 clean X-Spam-Score: -51.4 (---------------------------------------------------) X-Spam-Report: Spam detection software, running on the system "ollie.ringways.co.uk", has identified this incoming email as possible spam. The original message has been attached to this so you can view it (if it isn't spam) or label similar future email. If you have any questions, see Gary Stainburn for details. Content preview: On Thursday 20 December 2012 14:57:31 Ray Stell wrote: > createrole is really hard to find when you search for "create role." > Thanks. I always prefix any google search with 'postgresql' then whatever I need. [...] Content analysis details: (-51.4 points, 15.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -50 ALL_TRUSTED Passed through trusted hosts only via SMTP -2.6 BAYES_00 BODY: Bayesian spam probability is 0 to 1% [score: 0.0000] 0.2 AWL AWL: From: address is in the auto white-list 1.0 RING_SAFE RING_SAFE X-Pg-Spam-Score: -0.0 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Thursday 20 December 2012 14:57:31 Ray Stell wrote: > createrole is really hard to find when you search for "create role." > Thanks. I always prefix any google search with 'postgresql' then whatever I need. Try googling postgresql create role postgresql alter role The second one is to amend an existing role to add/remove privilidges -- Gary Stainburn Group I.T. Manager Ringways Garages http://www.ringways.co.uk -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin