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 34905329D5F for ; Thu, 16 Sep 2004 15:25:06 +0100 (BST) 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 34339-05 for ; Thu, 16 Sep 2004 14:24:53 +0000 (GMT) Received: from agnes.mbnet.pl (agnes.mbnet.pl [212.182.90.2]) by svr1.postgresql.org (Postfix) with ESMTP id A3895329C67 for ; Thu, 16 Sep 2004 15:24:55 +0100 (BST) Received: (qmail 1220 invoked from network); 16 Sep 2004 16:14:44 +0200 Received: from unknown (HELO localhost) (msz@127.0.0.1) by agnes.mbnet.pl with SMTP; 16 Sep 2004 16:14:44 +0200 Received: from 10.1.1.250 ([10.1.1.250]) by poczta.mbnet.pl (IMP) with HTTP for ; Thu, 16 Sep 2004 16:14:43 +0200 Message-ID: <1095344083.41499fd3d6d27@poczta.mbnet.pl> Date: Thu, 16 Sep 2004 16:14:43 +0200 From: msz@mikrobit.pl To: pgsql-admin@postgresql.org Subject: Restrictions for system tables MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.2 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200409/160 X-Sequence-Number: 14863 Hi I have many databases in Postgresql and I want to have one user who can connect only to one database but now if he querying pg_database (select * from pg_database) he gets list of all databases in my postgres. Is there any chanse to restrict access to pg_database, which gives in result of querying pg_database only database which is owned by my restricted user?