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 9E8A7329CD2 for ; Thu, 16 Sep 2004 18:37:25 +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 09920-05 for ; Thu, 16 Sep 2004 17:37:21 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 497B6329CBC for ; Thu, 16 Sep 2004 18:37:20 +0100 (BST) 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 i8GHbJCn013636 for ; Thu, 16 Sep 2004 17:37:19 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i8GHUCwF011435 for pgsql-admin@postgresql.org; Thu, 16 Sep 2004 17:30:12 GMT From: stig erikson X-Newsgroups: comp.databases.postgresql.admin Subject: allowing users to change the IP-addresses that are allowed to connect to postgresql Date: Thu, 16 Sep 2004 19:30:25 +0200 Organization: Hub.Org Networking Services Lines: 16 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8a4) Gecko/20040916 X-Accept-Language: en-us, en, sv, nn, nb, no, pl X-Enigmail-Version: 0.86.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/162 X-Sequence-Number: 14865 Hello. I have a postgresql 7.4.5 running. On the server i have a few databases, all owned and administered by different users. The users sometimes change access-rules to their databases, in particular they change access rules based on IP-addresses, which i have to do for them manually in pg_hba.conf. is there some way to avoid the pg_hba.conf-file? optimally i would like the access rights to be stored with the user and/or the database and tables. is this possible? allowing users to change them selfs. if not in 7.4.5, is it planned for 7.5 or 8.0? /stig