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 3648B52814 for ; Sat, 28 May 2005 08:14:40 -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 97003-05 for ; Sat, 28 May 2005 11:14:31 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 50B4252844 for ; Sat, 28 May 2005 08:14:31 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j4SBEVrM099210 for ; Sat, 28 May 2005 11:14:31 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j4SB8v2k098347 for pgsql-admin@postgresql.org; Sat, 28 May 2005 11:08:57 GMT (envelope-from news) From: Richard Hayward X-Newsgroups: pgsql.admin Subject: who can create schema? Date: Sat, 28 May 2005 11:13:48 +0100 Organization: Hub.Org Networking Services Lines: 17 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org X-Newsreader: Forte Agent 2.0/32.652 To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200505/316 X-Sequence-Number: 17745 PostgreSQL 7.3.2 I'm trying to investigate why users can create new schema within a database, without being explicitly being granted create permission on that database. I cant find a command that lists what privileges users have been granted within a database. Can they create new schema or not? And then, within a given schema, how could I list who can create new objects? Could anyone tell me? regards Richard