X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 10C5F9DC802 for ; Sat, 21 Jan 2006 07:48:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47288-03 for ; Sat, 21 Jan 2006 07:48:42 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id EE8699DC800 for ; Sat, 21 Jan 2006 07:48:37 -0400 (AST) Received: from bonito.ulb.ac.be (bonito.ulb.ac.be [164.15.59.220]) by svr4.postgresql.org (Postfix) with ESMTP id 995455AF088 for ; Sat, 21 Jan 2006 11:48:41 +0000 (GMT) Received: from mach.vub.ac.be (maxi.ulb.ac.be [164.15.128.8]) by bonito.ulb.ac.be (Postfix) with ESMTP id 6B0AA1E8 for ; Sat, 21 Jan 2006 12:48:37 +0100 (CET) Received: by mach.vub.ac.be (Postfix, from userid 21099) id 547EF8D0B; Sat, 21 Jan 2006 12:48:37 +0100 (CET) Received: from wwwdev.ulb.ac.be (resu1.ulb.ac.be [164.15.59.200]) by mach.vub.ac.be (Postfix) with SMTP id C7E7C8D07 for ; Sat, 21 Jan 2006 12:48:36 +0100 (CET) From: Stijn De Weirdt To: pgsql-admin@postgresql.org X-sender-IP: 82.174.7.192 Subject: alter role X-Mailer: Webmail ULB v3.0 Message-Id: <20060121114836.C7E7C8D07@mach.vub.ac.be> Date: Sat, 21 Jan 2006 12:48:36 +0100 (CET) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200601/251 X-Sequence-Number: 20339 hi all, i am looking for a way to list the attributes for a given role. i looked into the docs but didn't find anything directly usable. on a related problem, what actually happens when you issue a "ALTER ROLE someone SOME_ATTRIBUTES" if that user is connected to the db? (ie when do the changes happen and (for me more intersting) does something happen at all when the attributes are the same as the current ones?) many thanks stijn