Re: Restricting user access to databases

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 the line:

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