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 2F86B5283A for ; Tue, 7 Jun 2005 14:25:39 -0300 (ADT) 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 17805-05 for ; Tue, 7 Jun 2005 17:25:30 +0000 (GMT) Received: from mr1.surnet.cl (smtp1.surnet.cl [216.155.73.162]) by svr1.postgresql.org (Postfix) with ESMTP id 7958152881 for ; Tue, 7 Jun 2005 14:25:28 -0300 (ADT) Received: from smtp1.surnet.cl (216.155.73.168) by mr1.surnet.cl (7.0.031.3) id 42587EDE00C6C48B; Tue, 7 Jun 2005 13:24:46 -0400 Received: from smtp1.surnet.cl (mr1.surnet.cl []) by mr1.surnet.cl ([216.155.73.168]); Tue, 07 Jun 2005 17:24:46 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp1.surnet.cl (7.0.031.3) id 42587C6E00A1E86B; Tue, 7 Jun 2005 13:24:46 -0400 Received: from localhost (200.85.216.119) by cluster.surnet.cl (7.0.024) id 4276578F004F3559; Tue, 7 Jun 2005 13:25:17 -0400 Received: by localhost (Postfix, from userid 1000) id 846F5C20F80; Tue, 7 Jun 2005 13:25:43 -0400 (CLT) Date: Tue, 7 Jun 2005 13:25:43 -0400 From: Alvaro Herrera To: Dragan Matic Cc: pgsql-admin@postgresql.org Subject: Re: checking if user is connected as a superuser? Message-ID: <20050607172543.GF17902@surnet.cl> References: <42A423C4.6070404@panforma.co.yu> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <42A423C4.6070404@panforma.co.yu> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.618 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO X-Spam-Level: * X-Archive-Number: 200506/34 X-Sequence-Number: 17789 On Mon, Jun 06, 2005 at 12:21:56PM +0200, Dragan Matic wrote: > Is there a way to check if user is a superuser for the given cluster? alvherre=# show is_superuser; is_superuser -------------- on (1 fila) alvherre=# select current_setting('is_superuser'); current_setting ----------------- on (1 fila) -- Alvaro Herrera () La web junta la gente porque no importa que clase de mutante sexual seas, tienes millones de posibles parejas. Pon "buscar gente que tengan sexo con ciervos incendiándose", y el computador dirá "especifique el tipo de ciervo" (Jason Alexander)