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 31654D81FF for ; Thu, 13 Oct 2005 02:36:27 -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 76512-04 for ; Thu, 13 Oct 2005 05:36:23 +0000 (GMT) Received: from hotmail.com (bay111-f33.bay111.hotmail.com [64.4.17.43]) by svr1.postgresql.org (Postfix) with ESMTP id B7D1ED83C3 for ; Thu, 13 Oct 2005 02:36:23 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 12 Oct 2005 22:36:24 -0700 Message-ID: Received: from 64.4.17.200 by by111fd.bay111.hotmail.msn.com with HTTP; Thu, 13 Oct 2005 05:36:23 GMT X-Originating-IP: [164.164.12.25] X-Originating-Email: [ashu_shri@hotmail.com] X-Sender: ashu_shri@hotmail.com In-Reply-To: From: "ashish srivastava" To: pgsql-admin@postgresql.org Subject: Re: protecting database from internet access Date: Thu, 13 Oct 2005 11:06:23 +0530 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 13 Oct 2005 05:36:24.0094 (UTC) FILETIME=[0C8593E0:01C5CFB8] 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/143 X-Sequence-Number: 19215 Hi, I have to design authentication and authorization tables in the postgress database depending on the roles of the users. What strategy should i follow. The transcation is going to be at most secure i.e. https and ssl enable. can you help with some example. Thanks, Ashish >From: "codeWarrior" >To: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] protecting database from internet access >Date: Wed, 12 Oct 2005 08:13:31 -0700 > > From the postgreSQL docs: >16.7. Secure TCP/IP Connections with SSL >19.1. The pg_hba.conf file > 19.2. Authentication methods > 19.2.1. Trust authentication > 19.2.2. Password authentication > 19.2.3. Kerberos authentication > 19.2.4. Ident-based authentication > 19.2.5. PAM Authentication > 19.3. Authentication problems > >""ashish srivastava"" wrote in message >news:BAY111-F137A8BA63A48E213E01AF59F7B0@phx.gbl... > > 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 > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: don't forget to increase your free space map settings > > > > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Have you searched our list archives? > > http://archives.postgresql.org _________________________________________________________________ NRI SPECIAL OFFER!Zero balance account for 20 years! Get it now! http://creative.mediaturf.net/creatives/citibankrca/rca_msntagofline.htm