Re: help with pg_hba.conf
От
Isaac Dover
Тема
Re: help with pg_hba.conf
Дата
Msg-id
b560e3300905221039r4c8cc072o3dfb54c5a6a9509f@mail.gmail.com
Ответ на
Re: help with pg_hba.conf (Tom Lane)
Список
Дерево обсуждения
Re: help with pg_hba.conf Tom Lane <tgl@sss.pgh.pa.us>
Re: help with pg_hba.conf Isaac Dover <isaacdover@gmail.com>
Re: help with pg_hba.conf Tom Lane <tgl@sss.pgh.pa.us>
thank you _SO_ much. I'm not sure how I overlooked that, but it is far easier to manage using connect. I'm assuming that even if tables have public privileges granted, that they are not visible to people not granted connect privileges to the database?
Thanks,
Isaac
Thanks,
Isaac
On Fri, May 22, 2009 at 12:31 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Isaac Dover <isaacdover@gmail.com> writes:In recent releases (certainly 8.3) the better approach is probably to
>> As far as i can tell,
>> pg_hba.conf is the only manner in which to prevent users from connecting to
>> other users' databases. I've restricted roles to connecting only using
>> sameuser:
>>
>> host sameuser all 192.168.168.0/24 md5
use CONNECT privilege to grant or deny access. However that does have
some drawbacks if you intend to let users create their own databases
--- they have to remember to set the privileges properly on new DBs.
regards, tom lane
В списке pgsql-sql по дате отправления
