Re: user to database restriction?

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

In response to

Browse pgsql-admin by date

  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