Skip site navigation (1) Skip section navigation (2)

Re: Restricting user access to databases

From: Jared Sulem <jsulem(at)sulem(dot)freeserve(dot)co(dot)uk>
To: PostgreSQL Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Restricting user access to databases
Date: 2001-04-24 14:32:45
Message-ID: 3AE58E8D.4090209@sulem.freeserve.co.uk (view raw or flat)
Thread:
Lists: pgsql-admin
Jared Sulem wrote:

 > Is there anyway to make PostgreSQL automatically only grant access to
 > databases by their owners, and preferably database superusers, rather
 > than making lots of pg_hba.conf entries and password files?

Just had an idea.  Another token could be added to the pg_hba.conf file:
'owner'.  Then a line like:

host all 192.168.3.0 255.255.255.0 password owner

Would only allow users that owned the database they were trying to
access to login.  'owner' being like a virtual file containing only the
owner's name of the database, that the user is trying to access.

(Or is there already a way to easily do this?)

Jared





In response to

Responses

pgsql-admin by date

Next:From: Andrzej KwiatkowskiDate: 2001-04-24 15:21:09
Subject: error compiling 7.1 on Solaris 8 x86 (long)
Previous:From: Jared SulemDate: 2001-04-24 14:23:44
Subject: Re: Restricting user access to databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group