Allowing user to connect to a database?

Started by Carlos Olivaalmost 23 years ago2 messagesgeneral
Jump to latest
#1Carlos Oliva
carlos@pbsinet.com

Hi Forum,
What line should I enter in pg_hba.conf in order to allow all users with
subnet-mask starting at 255.255.255.0 into database "test"? Should it be:
Host test all 0.0.0.0 255.255.255.0 trust

Thanks in advance for your response

Carlos Oliva
Senior Programmer/Analyst
Positive Business Solutions, Inc.
Cincinnati, OH 45240-1640
(513) 772 - 2255 ext 129
carlos@pbsinet.com
Yahoo ID: ramboid_1997

#2Paul Thomas
paul@tmsl.demon.co.uk
In reply to: Carlos Oliva (#1)
Re: Allowing user to connect to a database?

On 18/06/2003 19:38 Carlos wrote:

Hi Forum,
What line should I enter in pg_hba.conf in order to allow all users with
subnet-mask starting at 255.255.255.0 into database "test"? Should it
be:
Host test all 0.0.0.0 255.255.255.0 trust

I think you would need something like

Host test all aaa.bbb.ccc.0 255.255.255.0 trust

where aaa is between 1 and 254 and bbb and ccc are between 0 and 254 (for
example 10.0.7.0 or 192.168.3.0)

HTH

-- 
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller 
Business |
| Computer Consultants         | 
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+