From: | Naomi Walker <nwalker(at)eldocomp(dot)com> |
---|---|
To: | Chris Ruprecht <chrup999(at)yahoo(dot)com>, Jon August <jon(at)internection(dot)com> |
Cc: | PostGreSQL Admin Group <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: user to database restriction? |
Date: | 2002-02-11 15:56:07 |
Message-ID: | 4.2.2.20020211085148.00ade100@ecint.ecinet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)postgresql(dot)org
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100 ext 242
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-02-11 16:02:51 | Re: restore whoes |
Previous Message | Markus Bertheau | 2002-02-11 15:55:51 | Re: pg_upgrade cmdline issue |