X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6CBD3D7B0F for ; Wed, 12 Oct 2005 07:23:20 -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 06029-10 for ; Wed, 12 Oct 2005 10:23:13 +0000 (GMT) Received: from hotmail.com (bay111-f13.bay111.hotmail.com [64.4.17.23]) by svr1.postgresql.org (Postfix) with ESMTP id BE76DD7232 for ; Wed, 12 Oct 2005 07:23:13 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 12 Oct 2005 03:23:16 -0700 Message-ID: Received: from 64.4.17.200 by by111fd.bay111.hotmail.msn.com with HTTP; Wed, 12 Oct 2005 10:23:16 GMT X-Originating-IP: [164.164.12.25] X-Originating-Email: [ashu_shri@hotmail.com] X-Sender: ashu_shri@hotmail.com From: "ashish srivastava" To: pgsql-admin@postgresql.org Subject: protecting database from internet access Date: Wed, 12 Oct 2005 15:53:16 +0530 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 12 Oct 2005 10:23:16.0589 (UTC) FILETIME=[F58E21D0:01C5CF16] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.312 required=5 tests=[AWL=-0.438, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0] X-Spam-Level: * X-Archive-Number: 200510/133 X-Sequence-Number: 19205 hi, please do the needful.. I am using j2ee on the server side and postgresql as the database to connect. This database is exposed to the internet. The user is shown a login page in which user enters its username and password. Password authentication takes place.This password is authenticated on the basis of password field in the userprofile table. some questions :- 1)can anybody tell me how to do this so that the database is at most secure on the internet ? 2)should i have different password(login password) for the connection string ? or connection string password should be same and authentication should be done by fetching the password value from the userprofile table for the coressponding user ? 3)Encrypting the password ? 4)Adding the password in the session so that once authentication is done user is allowed for authorization for different resources such databases,tables etc.. 5)providing some SSl or tunneling to the database ? please help with some examples.. i am presently using pg admin III on windows of postgresql. later on might switch to linux. i have read about pg_hba.conf file..But these things are not clear to me. Thanks, Ashish _________________________________________________________________ Finding it difficult to find your life partner?Here is your solution http://www.bharatmatrimony.com/ http://creative.mediaturf.net/creatives/bm05/bm_msn_tagoffline.htm