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
