Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9E78A632D07 for ; Tue, 3 Feb 2009 21:24:22 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 54076-01-10 for ; Tue, 3 Feb 2009 21:24:10 -0400 (AST) X-Greylist: delayed 00:27:40.371513 by SQLgrey-1.7.6 Received: from pooka.fabcat.org (pooka.fabcat.org [114.31.201.3]) by mail.postgresql.org (Postfix) with ESMTP id 9723A632CCA for ; Tue, 3 Feb 2009 21:20:12 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by pooka.fabcat.org (Postfix) with ESMTP id 5DCD03A8002 for ; Wed, 4 Feb 2009 11:52:33 +1100 (EST) X-Virus-Scanned: Debian amavisd-new at pooka.fabcat.org Received: from pooka.fabcat.org ([127.0.0.1]) by localhost (pooka.fabcat.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 424YbcfetYwR for ; Wed, 4 Feb 2009 11:52:22 +1100 (EST) Received: by pooka.fabcat.org (Postfix, from userid 1000) id C97833A8001; Wed, 4 Feb 2009 11:52:22 +1100 (EST) Date: Wed, 4 Feb 2009 11:52:22 +1100 From: raf To: pgsql-admin@postgresql.org Subject: How to prevent users from creating tables Message-ID: <20090204005222.GA19588@raf.org> Mail-Followup-To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/28 X-Sequence-Number: 31249 hi, in my database, normal users can't select, insert, update or delete anything directly. they can only call functions which are all security defining functions which give access to the data. that's the way i like it. however, i discovered that normal users can create new tables in the database. is there any way to prevent this? i couldn't find any grant/revoke syntax in the doco that looked relevant. cheers, raf