Re: How to provide db access to other systems

Quoting "VivekanandaSwamy R." <VivekanandaSwamyr(at)infics(dot)com>:

>
>

> Hi,
> We are using J2EE with PostgresSQL 8.1.0. OS : Wind
> In my system,i am having Postgre database.Now i want to provide database
> access to the front-end programmers.
> How can i do that?
> Please give me and explain the path...because we dont have any DBA..
> Im the new one for PostgreSQL
> Thanks & Regards
>
> Vivekananda.R | Software Engineer

>
> Infinite Computer Solutions | Exciting Times...Infinite Possibilities...
>
>
> SEI-CMMI level 5 | ISO 9001:2000
>
> Tel +91-80-5193-0000| Fax +91-80-51930009 | Cell No
> +91-9986463365|www.infics.com

Greetings,

You can allow your developers to use pgadmin by setting up the appropriate
users and groups (roles) in Postgres. Also as a matter of security, you should
only allow encrypted connections. You will need to generate a certificate
for the server and use the "hostssl" type with an "md5" password method (that
allows encrypted passwords to be used for your users) in the pg_hba.conf file.

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

______________________________________
This email account is being hosted by:
VCSN, Inc : http://vcsn.com