X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DD970D1CCAB for ; Sun, 7 Mar 2004 00:51:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 58968-02 for ; Sat, 6 Mar 2004 20:51:32 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 82723D1B4ED for ; Sat, 6 Mar 2004 20:51:29 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i270pH1Y064671 for ; Sun, 7 Mar 2004 00:51:17 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i270YKTs063314 for pgsql-admin@postgresql.org; Sun, 7 Mar 2004 00:34:20 GMT X-Newsgroups: comp.databases.postgresql.admin Subject: permission denied for schema pg_catalog From: Thomas Bjorn Andersen Organization: No Message-ID: <86smglbinj.fsf@gen-v.net> User-Agent: Gnus/5.110001 (No Gnus v0.1) Emacs/21.3 (usg-unix-v) Cancel-Lock: sha1:RHrrrYIlI2SlmZ1QniaXBHjTglM= MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Lines: 25 Date: Sun, 07 Mar 2004 01:33:20 +0100 X-Complaints-To: news-abuse@wol.dk To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/156 X-Sequence-Number: 12725 I'm sure I'm missing something very simple here... I've just upgraded from Postgresql-7.3 to 7.4.1. Whenever I log in as a user without superuser privs I get ERROR: permission denied for schema pg_catalog I found a posting somewhere that stated that a lot of defaults changed in 7.4 for security reasons, but I cannot seem to find out exactly what changed, and I'm not too keen on just granting ALL to everything for everyone. It seems to me that if I use the create_user utility (or indeed just CREATE USER), I end up with users that cannot really log in and do anything useful. Could someone point me in a direction where I can find some information on what settings I need to change in order to have "normal" users being able to use a specific database? Thanks, Thomas -- Thomas Bjorn Andersen +++ATH