On Tue, 2004-09-14 at 20:39, Goulet, Dick wrote: > Terry, > > In pga_conf.hba you can setup to restrict access to the other databases as in: > > # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD > # IPv6-style local connections: > host db1 usr1 ::1 > ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust > host db2 usr2 172.20.0.0 255.255.0.0 trust > host db3 usr3 172.17.0.0 255.255.0.0 trust
You can also put "sameuser" as the database, to restrict it to a user of the same name as the database. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== "But without faith it is impossible to please him; for he that cometh to God must believe that he is, and that he is a rewarder of them that diligently seek him." Hebrews 11:6 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
