What about through pg_hba.conf? We've set it up so to connect to a
database, you must be in pg_pwd (through pg_passwd), and know the
passwd. I will mention, that pg_pwd should not be clear text.
Any plan to encrypt it?
At 06:12 PM 2/10/02 -0600, Chris Ruprecht wrote:
>Jon,
>
>the only way I can think of doing this is by revoking the user's rights to
>the tables of the databases they have no business in.
>
>I know this is not exactly the answer you're looking for ...
>
>Best regards,
>Chris
>
>At 17:54 -0500 02/10/2002, Jon August wrote:
>>Can I restrict a user to a single database? It seems like any user can
>>connect to any database. . .
>>
>> -Jon
>>
>>---
>>Voice: (973) 560-9095 | Internection - Electronic Commerce, Internet
>>Cell : (973) 801-6071 | Consulting and Grade A Web Hosting Since 1995.
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>http://www.postgresql.org/users-lounge/docs/faq.html
>
>
>--
>Chris Ruprecht
>Network grunt and bit pusher extraordinaíre
>
>_________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100 ext 242