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