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 CFE7552923 for ; Tue, 31 May 2005 16:36:29 -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 32134-04 for ; Tue, 31 May 2005 19:36:25 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 71BBC529F8 for ; Tue, 31 May 2005 15:41:58 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j4VIfxZI016925; Tue, 31 May 2005 14:41:59 -0400 (EDT) To: Richard Hayward Cc: pgsql-admin@postgresql.org Subject: Re: who can create schema? In-reply-to: References: Comments: In-reply-to Richard Hayward message dated "Sat, 28 May 2005 11:13:48 +0100" Date: Tue, 31 May 2005 14:41:59 -0400 Message-ID: <16924.1117564919@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/325 X-Sequence-Number: 17754 Richard Hayward writes: > I'm trying to investigate why users can create new schema within a > database, without being explicitly being granted create permission on > that database. By default, they can't. Perhaps you granted create permission on the database to PUBLIC? Also, are you sure the users in question are not superusers? > I cant find a command that lists what privileges users have been > granted within a database. Can they create new schema or not? There doesn't seem to be a psql backslash command that shows permissions on databases; you'd need to look directly at pg_database, eg select datname, datacl from pg_database; regards, tom lane