> How do I set up my pg_hba.conf file to allow user "a" to only
> have access to databases x, y, and z; and user "b" to only have
> access to databases m, n, and o? The pgident authentication
> mechanism looks like the best candidate, but it does not seem
> to quite meet the requirements.
You have separate lines for databases x, y, z and m, n, and o. You
can't use 'trust' because that doesn't really know the user is who he
says he is. You can use secondary password files to specific users.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026