pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
protecting database from internet access
3+ messages / 2 participants
[nested] [flat]

* protecting database from internet access
@ 2005-10-12 10:23  ashish srivastava <ashu_shri@hotmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: ashish srivastava @ 2005-10-12 10:23 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: protecting database from internet access
@ 2005-10-12 15:13  codeWarrior <gpatnude@hotmail.com>
  parent: ashish srivastava <ashu_shri@hotmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: codeWarrior @ 2005-10-12 15:13 UTC (permalink / raw)
  To: pgsql-admin

  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"" <ashu_shri@hotmail.com> 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
> 





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: protecting database from internet access
@ 2005-10-13 05:36  ashish srivastava <ashu_shri@hotmail.com>
  parent: codeWarrior <gpatnude@hotmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: ashish srivastava @ 2005-10-13 05:36 UTC (permalink / raw)
  To: pgsql-admin

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" <gpatnude@hotmail.com>
>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"" <ashu_shri@hotmail.com> 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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-10-13 05:36 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-12 10:23 protecting database from internet access ashish srivastava <ashu_shri@hotmail.com>
2005-10-12 15:13 ` codeWarrior <gpatnude@hotmail.com>
2005-10-13 05:36   ` ashish srivastava <ashu_shri@hotmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox